Forum Discussion

mrfazio's avatar
mrfazio
New Member
6 years ago

Power query - Counting rows from all table in query editor but not shows data in the model tab

I want to consolidate counting rows from all my tables that I import from excel in power bi. I did that using a script in power query:   let Source = #shared, #"Converted to Table" = Record.ToTa...
Need Help
v-alq-msft's avatar
v-alq-msft
Community Support
6 years ago

Hi, mrfazio 

 

Is there any error message with these steps? What is the result for the query? 

 

Best Regards

Allan

mrfazio's avatar
mrfazio
New Member
6 years ago

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.

  • Smauro's avatar
    Smauro
    Solution Sage
    6 years ago

    You'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