Shared dataset for Power BI Report Server

[Anonymous]

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.

[d_gosbell]

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.

[Anonymous]

Hi,

we have oracle database which power-bi connects to.  How to use Analysis Services Tabular Instance, please guide.

Thanks.

[d_gosbell]

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...

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.