Forum Discussion
Power BI desktop entity sharing
Hello,
I have created several Power BI desktop reports and things are going well. Several different reports have the same or similar entity relationship models. It seems tedious to recreate the same model for each new report. Is there a way to import them (tables or data flows) with the relationships between the entities, already defined?
Thanks!
Hi asbpowerbi,
I'd like to suggest you parameterized your report to a template, then you can use different connection strings to generate reports with similar design and different data source.
If you mean to use the same data source to design different reports, you can create a dataflow with these data sources and directly can get data from created dataflow on power bi desktop side.
Creating a dataflow - Power BI | Microsoft Learn
Power Query Dataflow connector - Power Query | Microsoft Learn
Regards,
Xiaoxin Sheng
1 Reply
Hi asbpowerbi,
I'd like to suggest you parameterized your report to a template, then you can use different connection strings to generate reports with similar design and different data source.
If you mean to use the same data source to design different reports, you can create a dataflow with these data sources and directly can get data from created dataflow on power bi desktop side.
Creating a dataflow - Power BI | Microsoft Learn
Power Query Dataflow connector - Power Query | Microsoft Learn
Regards,
Xiaoxin Sheng