Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-25-2025 01:44 PM
@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.
2 - Create a parameter in Powerquery and name it.
3 - Concatenate the Parameter with your SQL query.
Follow the final steps in the documentation to bind the parameter with your Report parameter under dataset properties.
Good luck!