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
madhumnair
New Member

Combining different PBIX dataset

I need expert help on this issue,

How to combine the data set from 2 or more different Powerbi (PIBX) files uploaded on to workspace, to generate 1 single report in another PIBX.

In my case these 3 PIBX reports are uploaded from 3 different Desktops but accessible in 1 point on workspace. The data cannot be aggregated any where else.

Please suggest if there is a workable solution, or this is not supported in PowerBI.

1 ACCEPTED SOLUTION
arpit2196
Frequent Visitor

Hi Madhumnair, 

Yes, It's Possible !!

You can establish a live connection to a  shared dataset in the Power BI service, and create many different reports from the same dataset.

----------------------------------------------------------------------------------------------------------------------

Step 1 - Open power bi report

Step 2 - Enable 'DirectQuery for power bi datasets and AS' feature in the power bi report.

To enable, go to File -> Options and Settings -> Options -> Preview features -> Select checkbox for 'DirectQuery for power bi datasets and AS' -> Click Okay.

PBI_datasets.png

 

Step 3 - Add Datasets into power bi report

 

PBI_datasets2.png

 

Add Dataset of Report1 and Report2  one by one in the report.

In this way, we can use multiple datasets in the power bi report.

 

----------------------------------------------------------------------------------------------------------------------

Connect to datasets in the Power BI service from Power BI Desktop 

 

If I answered your question, please mark this thread as accepted solution and  just  give kudos on this post  👍

 

Thank you !

View solution in original post

2 REPLIES 2
madhumnair
New Member

Thankyou arpit2196 . This solution worked .

Need to set the source Dataset in directquery mode. And also you get an option to select the relevent tables to be linked. The remaining queries and aggregation need to be set in the New PIBX (the combined file).

12345.png

123456.png

arpit2196
Frequent Visitor

Hi Madhumnair, 

Yes, It's Possible !!

You can establish a live connection to a  shared dataset in the Power BI service, and create many different reports from the same dataset.

----------------------------------------------------------------------------------------------------------------------

Step 1 - Open power bi report

Step 2 - Enable 'DirectQuery for power bi datasets and AS' feature in the power bi report.

To enable, go to File -> Options and Settings -> Options -> Preview features -> Select checkbox for 'DirectQuery for power bi datasets and AS' -> Click Okay.

PBI_datasets.png

 

Step 3 - Add Datasets into power bi report

 

PBI_datasets2.png

 

Add Dataset of Report1 and Report2  one by one in the report.

In this way, we can use multiple datasets in the power bi report.

 

----------------------------------------------------------------------------------------------------------------------

Connect to datasets in the Power BI service from Power BI Desktop 

 

If I answered your question, please mark this thread as accepted solution and  just  give kudos on this post  👍

 

Thank you !

Helpful resources

Announcements
Europe Fabric Conference

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

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors