Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Sudhavi_84
Helper V
Helper V

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.

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

1 ACCEPTED SOLUTION
d_gosbell
Super User
Super User

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

2 REPLIES 2
Sudhavi_84
Helper V
Helper V

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
Super User
Super User

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.

Helpful resources

Announcements
Fabcon_Europe_Social_Bogo

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Find out what's new and trending in the Fabric Community.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.