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" ins...
shared dataset
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