Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
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?
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.
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
3 | |
2 | |
1 | |
1 | |
1 |
User | Count |
---|---|
5 | |
5 | |
4 | |
4 | |
3 |