Forum Discussion
Shared dataset for Power BI Report Server
Hi,
As i come from SAP BO BI background where we created single Universe(data model/dataset) and used in hundreds of reports. We are going to stop SAP Product. We are moving to Power BI.
I have seen the shared dataset can be implement in power bi service.
Question : Is there way to have single dataset for Power BI Report Server so that we use same dataset for all reports.
I google but could not find to solution to implement shared dataset for PBIRS.
Kindly advice how to implement this solution.
Moreover, our back-end database is Oracle.
Thanks.
3 Replies
You cannot share a dataset from a Power BI Report in Power BI Report Server. The way you would do this on-prem is to use an Analysis Services Tabular instance and publish your model there. Then you can create multiple Power BI Reports (or paginated reports) that all connect to a single tablular data model.
Microsoft has tutorials on getting started with Analysis Services here https://docs.microsoft.com/en-us/analysis-services/tutorial-tabular-1400/as-adventure-works-tutorial?view=asallproducts-allversions
It's the same data engine that Power BI uses (so your existing DAX and Power Query imports should still work) , but the UI is slightly different.
