Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi All
Some power query support required!
In my queries, i need to build pivot versions of my source data, while retaining the source data itself for various visualisation in my report.
The way I did this was simply duplicating the original query, unpivotting and formatting etc.
What I have realised since is when I updated the source of original query, the pivot version does not update - it remains based on v1 of the source data. I am now messing about with the advanced editor for each "pivot" version of my queries and it's all rather time consuming.
So my question would be can I have a query with its source being another loaded query in the editor? Or does it always have to be my original excel / csv raw files?
I appreciate that a work around could be just overwriting the source data rather than using advanced editor to change it to a new file path, but it would be interesting if my suggested solution could actually be done.
thank you all,
GC4002
Solved! Go to Solution.
Yes. That is exactly what the Reference feature is. When you right click on a query to Duplicate it, choose Reference instead. It uses the output of one query as the input of the new one.
If this works for you, please mark it as the solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
Yes. That is exactly what the Reference feature is. When you right click on a query to Duplicate it, choose Reference instead. It uses the output of one query as the input of the new one.
If this works for you, please mark it as the solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
81 | |
66 | |
58 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |