Forum Discussion
Power Query Table
Hi,
I have power query table called "tbl_1".
I need to have another table called "tbl_2" sourcing data at "tbl_1" step no. 4.
There are other steps also after step#4. I don't want to duplicate table because it was decrease its efficiency. How can it be achieved without duplicating table?
7 Replies
Thanks 🙏 🙏
Hi,
While applying the Record system, getting error: "Formula.Firewall: Query 'Query1' (step 'Query1') references other queries or steps, so it may not directly access a data source. Please rebuild this data combination."
Staging Query in not visible for creating the visuals in meta solution.
refer to the following
https://www.youtube.com/watch?v=5HS6rj4RL2Q&ab_channel=Goodly
I highly repect Imke, but i have never encountered the source query is evaluated twice if you do a refresh all.
Select the step after step4. Right click on the step and choose 'extract previous'. You will be asked for the name of the new query. Refer to the new query in your tbl-2 query
