Forum Discussion
Solved
Can we retain table relationships when using 'Add Power BI Dataset Connection' in Report Builder?
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 P...
The solution can be found here:
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.
I agree. Why doesn't report builder retain the relationships/joins when connecting to your dataset/data model? You have to create the relationships twice? I feel like this is a design flaw.