cancel
Showing results for 
Search instead for 
Did you mean: 
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
May 23 2022 epsiode 5 without aka link.jpg

The Power BI Community Show

Welcome to the Power BI Community Show! Jeroen ter Heerdt talks about the importance of Data Modeling.

charticulator_carousel_with_text (1).png

Charticulator Design Challenge

Put your data visualization and design skills to the test! This exciting challenge is happening now through June10th!

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

Check it Out!

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

Power BI Release May 2022 768x460.png

Check it out!

Click here to read more about the May 2022 updates!

Top Kudoed Authors