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

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

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?

1 ACCEPTED SOLUTION
Anonymous
Not applicable

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

View solution in original post

2 REPLIES 2
Anonymous
Not applicable

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
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
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

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

Top Solution Authors