Forum Discussion

Sudhavi_84's avatar
Sudhavi_84
Helper V
3 years ago
Solved

Power BI Datasets

Hi Experts, We are using Power BI Reporting Server having SSEE with Software Assurance license.   Currently all our reports we upload in Visual Studio Github and then Prod Team will move into Prod...
Need Help
  • d_gosbell's avatar
    d_gosbell
    3 years ago

    No you cannot shared datasets in Report Server like you can on the Power BI cloud service. The dataset inside a pbix file on Report Server cannot be accessed by any other report.

     

    If you want to create a tabular data set that can be used across multiple reports then you could create these as SQL Server Analysis Services models. Then you can connect from multiple pbix or rdl reports to these models.

d_gosbell's avatar
d_gosbell
Super User
3 years ago

No you cannot shared datasets in Report Server like you can on the Power BI cloud service. The dataset inside a pbix file on Report Server cannot be accessed by any other report.

 

If you want to create a tabular data set that can be used across multiple reports then you could create these as SQL Server Analysis Services models. Then you can connect from multiple pbix or rdl reports to these models.