Forum Discussion
Anonymous
7 years agoNot applicable
Merge refreshes data from all nested tables
Hi, I am using Power BI Pro. I have two tables in Power BI - A and B. I merged them using 'Merge Queries' into table C. I then merge C and another table D into E. E = C + D C = A + B ...
Nolock
Resident Rockstar
7 years agoHi Anonymous,
we discussed a similar topic a few days ago: https://community.powerbi.com/t5/Power-Query/Using-Function-InvokeAfter-function-to-stop-the-SQL-connection/m-p/760863#M25409
- Anonymous7 years agoNot applicable
Hi Nolock,
Thanks for the link.
Basically, the scope of Table.buffer is within the same table. If the table is called by another table, the original table will be refreshed. There is no way around it.
The Power BI team should look into it as it is increasing API/ database hits.