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
Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

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 May 31st!

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

Power BI Release May 2022 768x460.png

Check it out!

Click here to read more about the May 2022 updates!