Shared data sets in PBRS

[Anonymous]

Hi,

We are looking to implement Power BI Report Server for initially about 50 reports. All data will be sourced from an Oracle DW.

Our initial idea was to build an "analytical data model" inside Power BI Report Server, a shared dataset that all 50 reports could use in order to simplify things and minimize the number of queries made to Oracle. However, according to the below forum post, sharing datasets across PBIX files is not possible? 

https://community.powerbi.com/t5/Report-Server/Sharing-data-sets-in-Power-BI-Report-server/m-p/49621...

Have I misunderstood something? This seems like a necessary functionality for organizations with hundereds/ thousands of reports in Power BI Report Server.

[Anonymous]

I'm just looking for confirmation that I have understood this correctly.

It seems like our options are:

1. Import with every PBIX report querying Oracle whenever data is refreshed. Try to consolidate reports into as few PBIX files as possible.

2. SSAS - live connection

3. SSAS - import

[Anonymous]

You can make use of old fashione SSRS shared data sets if you wish.

You would write your queries into shared datasets from your Oracle and deploy these onto your PBI-SSRS server. Then set these shared datasets on a refresh schedule.

You can then find these datasets using the oData endpoints using

http://YourServerName/YourSSRSPath/API/v2.0/datasets

Once you have the GUID for the dataset you are intersted in you can access it using an oData source in PBI Desktop with its URL that will look like this

http://YourServerName/YourSSRSPath/API/v2.0/datasets(cd9269ae-13cd-4a04-98f5-8eba0d307ec9)/data

We use this for a number of fixed datasets we use in all our reports (lists of users, lists of projects etc)

The link to the docs about using SSSR oData endpoint is in this thread

https://community.powerbi.com/t5/Report-Server/PBIRS-reports-dataset-stored/td-p/451058