Solved: Re: Power BI Datasets

Sudhavi_84 · ‎10-04-2022

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.

So my question is can we still use Power BI Datasets? because we don't have access to workspace or anything.

As a dev we just having access to develop and connect SQL Source and bring the data but how can I create SQL Connection in Dataset and then reuse that dataset all the time please?

Thanks in Advance

d_gosbell · ‎10-04-2022

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.

View solution in original post

Sudhavi_84 · ‎10-05-2022

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?

d_gosbell · ‎10-04-2022

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.