J-Usef
New Contributor III

@fellipeao This is the only way I found that works well with databricks since positional arguments (?) was a fail for me. This is the latest version of paginated report builder.
https://learn.microsoft.com/en-us/power-bi/paginated-reports/report-builder/connect-snowflake-databr...

Once connected to databricks, you can choose any random table and then go to advanced editor and make these changes: 

1 - Use Nativequery funtion to be able to insert your SQL query:

Value.NativeQuery(Databricks.Catalogs ... etc
2 - Create a parameter in Powerquery and name it.
3 - Concatenate the Parameter with your SQL query. 
JUsef_0-1758832983574.png

Follow the final steps in the documentation to bind the parameter with your Report parameter under dataset properties. 
Good luck!