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
2022 Release Wave 1 760x460.png

2022 Release Wave 1 Plan

Power Platform release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.

Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

Jan 2022 Dev Camp 768x460 copy.png

Power BI Dev Camp- January 27th, 2022

Mark your calendars and join us for our next Power BI Dev Camp!

Top Solution Authors