Forum Discussion
Append Table data refresh
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 !
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
2 Replies
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
LinkedinI untick and tick again the refresh setting and it works , thank you !
