Skip to main content

Power BI

Needs Votes

Power BI Report Builder - Enable Query Designer to recognize the data model relationships built in a Power BI dataset

Vote (8) Share
Trenton See's profile image

Trenton See on 27 May 2021 21:33:31

The table relationships built within the data model of a Power BI dataset are not currently recognized in Power BI Report Builder's Query Designer as they are in Power BI Desktop and service. This means that users have to go through a workaround by first building the report in Power BI Desktop, recording each step using the Performance analyzer, and then copying and cleaning up the DAX code to use in Power BI Report Builder.

If Power BI Report Builder's Query Designer could recognize all of the table relationships built into a Power BI dataset on the server, then it would allow users without SQL nor DAX knowledge to more easily build paginated reports from a managed shared dataset.