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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
Anonymous
Not applicable

Reusing a Query and retaining applied steps

Hello,

 

I have a dataset withh approx 1M rows.  I have been using PowerBI as an ETL tool and the query has many applied steps.

Now I need to use the same dataset in another report.  The problem is that I need to add data for this report, so I can't simply use the Power BI Service as a connector.

I can copy the query over, but then every time I need to adjust the steps in one file, I have replicate everything in the new file.  OR delete the old query, copy and paste again, and recreate all the measures and relationships.

 

I can also use Power Query to do the ETL, but I'd rather not have a middle man complicating things.

 

Is there no way for multiple reports to share a common query, or to syncronize them?  Use one PBIX as a source for another?

7 REPLIES 7
Girus
Regular Visitor

Hi, I am having the same issue, does anyone know if any capability has been added. I am working an a master Calendar for my company and I will end up using this table in many reports, but I keep adding and tweaking the calendar power query code. It would be nice to have it available and sync it accross all the reports without having to copy paste the M code.

tparks75
New Member

The easiest way I have found to perfrom this that doesn't involve extensive effort is by grabbing the code from the query while in "edit query mode" (right-click the query and select "advanced editor").  I have copied everything in the editor and then created a blank query in my other report. After pasting everything into the blank query, it ran and applied every step from the prior, as if it were a copy, but it was not dependant on the original source.  Actually, i had to resolve a few minor errors since i had made updates to the query in my first report which referenced queries not yet in my new one, so i applied the same steps to copy the referenced queries over and all was well within 5 minutes total!

Anonymous
Not applicable

Thank you for this! I wish that the OP would accept this as a solution becuase it works perfectly for what everyone on this thread is looking for. I'll add that you need to paste the Advanced Editor code into the Advanced Editor for the new Query, as opposed to pasting the code into the blank query itself.

Anonymous
Not applicable

Are you trying to add additional data in your dataset? I think you could edit your source after you add the additonal data to your dataset providing that metadata are the same. 

Anonymous
Not applicable

Yes, I need to combine the data with another data source.

That it self is fairly trivial.  That said, if I need to edit the query in the original file (call it the "Master") due to ongoing "data cleansing" I need to replicate those steps in the other PBIx filea.  The more PBIx files I have relying on this "cleansed data" the more times I have to repeat entering the same query steps, and the more likely errors are introduced.

 

Power BI offers the same functionality as Power Query in terms of query maniupulation, but no reasonable way of resuing the output.  In a perfect world, I could just connect to the dataset in Power BI Service AND combine with other data.

 

I believe I saw a script on GitHUB that allows users to extract data tables from a PBIx file...  I suppose I could automate that and load it into a SQL table.  But it's just a bit nuts that I have to do that.

Anonymous
Not applicable

I found this interesting solution: https://powerbi-pro.com/reuse-your-queries-in-power-bi/

But it's really only interesting because of how ridiculous it is to use a .txt file to accomodate query sharing....  Smiley LOL

Anonymous
Not applicable

I do hope query using will be implemented sometimes in the future. In the meantime, I guess this should work. Perhaps you could submit this as an idea, maybe we could get this implemented soon 

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.