Forum Discussion
How Append works?
You should only have to refresh Table C. Because that is an append of A & B it will refresh those sources. I put together a test append then added records and refreshed only my append table:
before and after refresh Table C
Refresh Data C.
When you refresh a table, it checks dependencies on any other table that is referenced, and will refresh those as well.
It sounds like Tables Data A and Data B are not needed in the model, they only need to exist in Query Editor so that Data C is created properly. Have you disabled load to the data model for these tables?
Right click on Data A in Query Editor. Make sure that "Include in Report Refresh" is checked and "Enable Load" is NOT checked. Do the same for Data B.
Data C should have BOTH checked.
Now, when you refresh Data C, everything will happen as planned.
When you refresh a table, it checks dependencies on any other table that is referenced, and will refresh those as well.
So tables A,B,C will be refreshed?
Have you disabled load to the data model for these tables?
Nope, but i dont use the refresh button i just manually refresh the tables i need from the Fields Panel
Right click on Data A in Query Editor. Make sure that "Include in Report Refresh" is checked and "Enable Load" is NOT checked. Do the same for Data B.
I did this once and the information of data "A" dissapeared and same thing happened for the info of data "A" that was on data "C"