I'm trying to recreate a Power BI table report as a paginated report. In Power BI Report Builder, I was able to connect to the Power BI dataset by right-clicking on Data Sources and selecting 'Add Power BI Dataset Connection'. However, problems arose when adding the dataset. In Query Designer, I can see all 10+ of the tables in my Power BI dataset. I was able to drag & drop the necessary fields into the workspace, but when I executed the query, I had a ton of duplication issues. It was obvious the tables were no longer joined by related fields. Is there any way to use the 'Add Power BI Dataset Connection' in Power BI Report Builder for Power BI datasets with multiple tables AND retain the relationships? Power BI Report Builder is pretty cumbersome and it would be amazing to add Power BI datasets with relational integrity. That would make life so much easier.

The solution can be found here:https://community.powerbi.com/t5/Desktop/Relationship-between-tables-in-Power-BI-Report-Builder/m-p/1017365 In summary, when you connect to power bi dataset from power bi desktop/report builder, the connection mode is set as live connection which means you can't do any modification on the data model(e.g.: table relationship) so you can't see the relationship. However, you can use the RELATED function to get field from dimension tables into a single fact table. Once all of the required fields are in one table, you can build the query in Power BI Report Builder from the single source. It's certainly a pain, but it works.

Can we retain table relationships when using 'Add Power BI Dataset Connection' in Report Builder?

Forum Discussion

Related content

Relationship

Power Bi report builder connection

Relationships

Relationship Issue

Relationships connection