Forum Discussion
Table Refreshes
I have a table connected to our SQL database and I just have a few refresh questions... So I have two tables connected through a middle table:
I right clicked "Co" from the M3 Billing table, clicked "Add as New Query", converted from a list to a table, removed the duplicates and it allowed me to establish a connection between M3 Billing and Delta Account as you can see.
So my question here is, will my middle table refresh with new "Co" values as they come in from the M3 Billing table? I wasn't sure if the middle table would capture new information as it comes in or if it remained static.
My other question is, my M3 Billing table appends two other billing tables that are set up the same way. So M3 Billing is basically 3 tables in one. When my other two billing tables are refreshed, will new values coming in also be added to the appended queries I've added to my M3 Billing table?
Hi Anonymous,
Based on my test, both the Middle table and appended table will be updated accordingly once you refresh the underlying tables.
At first, I import two tables from SQL database, I append them into a new query and create a middle query table as you said. Then I updated my table in SSMS.
Once I click refresh in Power BI desktop, data are updated in the appended query and middle query as below:
Regards,
Frank
2 Replies
Hi Anonymous,
Based on my test, both the Middle table and appended table will be updated accordingly once you refresh the underlying tables.
At first, I import two tables from SQL database, I append them into a new query and create a middle query table as you said. Then I updated my table in SSMS.
Once I click refresh in Power BI desktop, data are updated in the appended query and middle query as below:
Regards,
Frank
v-frfei-msft thank you so much for clarifying! I assumed that was how it had to work otherwise people would have to recreate that middle table frequently. Thanks!