Append Table data refresh

[butterscotch]

Hello everyone!

im facing an issue with data refresh for my appended table.  Below is my scenario (not a real datasets)

these are the tables that i had :
location:Excel Sheet

I appended these 4 tables into 1 table:
location : Power BI

then, i appended table that shares same value of type and factory:
location : Power BI

The issue is that whenever i change date column in excel file for process C or D, the changes only occur in the 1st appended table and not both appended table. why is that ? how do i fix so that when i change any data in excel file, every table in power bi will be updated

Thank You !

[PijushRoy · Accepted solution]

Hi @butterscotch 

With the sample data, can you please create and share PBIX file link (Google Drive/Dropbox/OneDrive) to reproduce the issue.
Check below option should turn on for all Source file and Append File

<p><br />Let me know if that works for you</p>

If your requirement is solved, please mark THIS ANSWER as SOLUTION ✔️ and help other users find the solution quickly. Please hit the Thumbs Up 👍 button if this comment helps you.

Thanks
Pijush
Linkedin

[butterscotch]

I untick and tick again the refresh setting and it works , thank you !