Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Shared data sets in PBRS

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/496212#M7352

 

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

shared dataset

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    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's avatar
      Anonymous
      Not applicable
      7 years ago

      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