Forum Discussion
How to reuse data model in Report Server
In Power BI Desktop you can create a PBIX with a import mode data model with a SQL on prem data source, merged queries, relationships, dax measures and a report. When this is published to Power BI Service it splits the report into 2 objects (the dataset and report). More reports can then be created using the same data model.
However, I think if you load the same Power BI Desktop PBIX into Report Server, it just creates one object. The data model can not be used by multiple reports. This means the PBIX has to be duplicated and edited for each report, which then doubles the maintenance work of the queries, relationships and DAX measures.
I appreciate that SSAS could be used to just create one data model which could have multiple Report Server Power BI reports, but I am using a legacy system and only Report Server is currently available.
So my questions is ..... is it possible to somehow upload and use the same data model across multiple Power BI reports in Report Server (without SSAS or Power Bi Services).
Please only reply to this question if you run Power BI reports on Report Server instead of Power Bi Services, because they are fundamentally different. Thank you.
Hi, speedramps
Currently, Power BI Report Server doesn't support the ability to reuse the semantic model of a report. As you described, you can use one semantic model in Power BI Service to build additional reports.
Best Regards
Jianpeng Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
Hi, speedramps
Currently, Power BI Report Server doesn't support the ability to reuse the semantic model of a report. As you described, you can use one semantic model in Power BI Service to build additional reports.
Best Regards
Jianpeng Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you Jianpeng.
Are you an Microsoft Employee or volunteer helper on the forum.
I ask because it would be useful to have an official Microsoft answer regarding this matter.
- I believe we are both correct that "Get Data" can not be used to access a Report Server dataset in another report.
However, I need to convince other stakeholders. So it would be useful to have some official Microsoft documentation explaining this.
I will accept you answer once I have explored all options. Many thanks
