Forum Discussion
Power query - Counting rows from all table in query editor but not shows data in the model tab
Hi,
It shows the results when I transform the data, but when I apply the changes I cannot manipulate the data in report because it not shows the data that was tranformed.
Solution SageYou're not missing anything, it's just reference and context.
When in PQ Editor, you are referencing all your queries via #shared. This works, because at this time all your queries are computed, and ready to be referenced on a new query. However, when applying changes, Consulta1 query gets only the direct references of Consulta1 (and all functions) from #shared, and since all other queries are never directly referenced, and probably not even calculated at the time of Consulta1's calculation, they are simply not there. Thus, an empty table.
Edit: You can see that on Query Dependencies