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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
anywhereanytime
Helper III
Helper III

Is it possible to "merge" multiple Queries - PBIX format - in Power BI Desktop?

A member of our team, did a number of "ODBC Queries" on their laptop and the result was a .PBIX = now we are trying to "merge" these on a differnt team members laptop?  However, each time we "open a single PBIX" it opens a new instance of Power BI Desktop?

2 REPLIES 2
alex-potter
Advocate IV
Advocate IV

It sounds like the issue is with the ODBC queries being split between multiple .PBIX files?

 

The best way to get all of the queries into the same PBIX file is to open the queries in the query editor, and copy the advanced editor code of each one into a master PBIX file. 

Steps:

  1. Create Master "Merge" PBIX file
  2. Open first ODBC PBIX file
  3. Open Query Editor
  4. Click "Advanced Editor" button
  5. Copy Code
  6. Create new Blank query in Master "Merge" PBIX file
  7. Paste copied code into blank query and close the advanced editor
  8. Name the query the same name as the query you copied from.
... Rinse and repeat until you are done
Alex Potter
Lead Visualization Engineer
Luxoft Inc.
Haegi
Advocate V
Advocate V

Hello,

 

I'm not sure but you want to use the same pbix file for all of your member (team) ?

 

I make some supposistion

1 - You can deploy the pbxi file in the cloud like onedrive for business and each member of you're can work with it. 

2- You want to merge some odbc queries in the same data model with powerbi desktop and it's possible with the "merge queries" functionality. It's in the queries editor.

 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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