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.

Sudhavi_84's avatar
Sudhavi_84
Helper V
3 years ago

Great Thank you for letting me know. I am bit new to this. We have Visual Studio but seems like we don't have option to select SSAS on it. I may need to ask Admin and need to request them to get install or activate the analysis service tabular model in it. So we can create Star schema in SSAS and simply we can access from Power BI Get Data? I will check online too.

 

Please any good links to follow this?