Forum Discussion
Reusing a Query and retaining applied steps
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.
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.... :smileylol:
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