cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
thale
Helper II
Helper II

One dataset for serveral reports

Hi,

 

i have a database which I want to query with odbc and with SQL to create a big master dataset or something like that in Power BI. With this master dataset I want to create serveral reports. 

 

How do I do this? 

 

For creating a dataset in the Power BI Report Server Web interface I need to open Report Builder. Why? I just want to inser my sql and the source...

 

It seems like I need some help 🙂 

1 ACCEPTED SOLUTION
luisrh
Resolver III
Resolver III

Power BI datasets and paginated report datasets are different in PBI RS.   For creating RDL reports you can use shared datasets that can drive multiple RDL (paginated reports).    See here for details.

Manage Shared Datasets - SQL Server Reporting Services (SSRS) | Microsoft Docs

Power BI Datasets are tied to a PBIX file -  you can create multiple visualizations there as well as tabs - each tab can be a report.  

To create those datasets you should look here.  It happens in power bi desktop,  not Report builder.

Connect to data in Power BI Desktop - Power BI | Microsoft Docs

 

regards,

Luis H

 

 

View solution in original post

1 REPLY 1
luisrh
Resolver III
Resolver III

Power BI datasets and paginated report datasets are different in PBI RS.   For creating RDL reports you can use shared datasets that can drive multiple RDL (paginated reports).    See here for details.

Manage Shared Datasets - SQL Server Reporting Services (SSRS) | Microsoft Docs

Power BI Datasets are tied to a PBIX file -  you can create multiple visualizations there as well as tabs - each tab can be a report.  

To create those datasets you should look here.  It happens in power bi desktop,  not Report builder.

Connect to data in Power BI Desktop - Power BI | Microsoft Docs

 

regards,

Luis H

 

 

Helpful resources

Announcements
August 1 episode 9_no_dates 768x460.jpg

The Power BI Community Show

Watch the playback when Priya Sathy and Charles Webb discuss Datamarts! Kelly also shares Power BI Community updates.

Power BI Dev Camp Session 24 without aka link and time 768x460.jpg

Ted's Dev Camp - July 28, 2022

Watch Session 24 of Ted's Dev Camp along with past sessions!

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Top Solution Authors