Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Bodo
Helper I
Helper I

Report Builder loses table joins information if using datasets from the Power BI service

Hello all,

 

This is my usecase:

1. I create a report with many relationships between tables in Power BI Desktop
2. I published my report in Power BI service
3. I connect to the Power BI Service in Power BI Report Builder
4. I use the Query Builder in Design Mode and select columns from different tables

 

The result in the Report Builder is completely different than the one with Power BI Desktop, because the Report Builder does not take the connections between tables into account. There was a similar request from @ola1996  three years ago. It was marked as solved, but it is actually not and the bug still exists.

 

The ability to use data models from Power BI Desktop in Power BI Report Builder would be an awesome feature.

Is there an expected date when this bug will be fixed?

1 REPLY 1
d_gosbell
Super User
Super User

Power BI semantic models work fine in paginated reports. The only caveat is that they have the same limitation as the Analyze in Excel feature in that they require explicit measures (see Explicit Vs Implicit DAX Measures in Power BI - RADACAD) if you are just dragging numeric columns into the query builder that could explain the behaviour you are seeing.

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors