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,
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
When I make any changes to E, it refreshes the data from all the nested downstream tables.
The data in the tables is coming from a mix of SQL database, json and an REST api.
Each table contains around 50-70k rows.
The whole refreshes takes about 2-3 hours.
This is very annoying as everytime I make a small change to any of the tables, I have to wait for hours before I can make the next change.
Is it possible to set so it doesn't refresh the nested tables?
Hi @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
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.
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.