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

[Bodo]

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?

[d_gosbell]

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.