Forum Discussion
Can we retain table relationships when using 'Add Power BI Dataset Connection' in Report Builder?
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.
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.
What if you have an extremely large dataset that can't handle one single table? I don't understand why you have to create the relationships twice. Seems to be a design flaw to me.