Forum Discussion

Anonymous

Not applicable

6 years ago

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

Shared Dataset in Power BI Report Server

d_gosbell

Super User

6 years ago

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
Not applicable
6 years ago
Hi,
we have oracle database which power-bi connects to. How to use Analysis Services Tabular Instance, please guide.

Thanks.
- d_gosbell
  Super User
  6 years ago
  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.

Forum Discussion

Shared dataset for Power BI Report Server

Related content

Report Sharing

Report Sharing without sharing dataset

Report sharing strategy

Share report with external

Question about shared datasets