Forum Discussion
Solved
Incremental Refresh loading file from Excel
I have a data in the excel file located in the sharepoint, Each excel file has a name begin with date when I loaded all the excel file in the sharepoint I apply the filter into date from name with Ra...
Hi,
As Data is coming from Sharepoint location, try Date Modified for configuring Inremental refresh. Using this column will make sure that the changes inside the Excel are taken up during refresh.
Hello Jidapa18
Incremental refresh is not updating because you are using file name date, which doesn’t change when the file content changes. In Microsoft Power BI, refresh only happens when the filter column value changes.
Try Use Modified Date from SharePoint instead of file name, so any file update triggers refresh and your data updates correctly.
If my response helped you, please consider clicking
Accept as Solution ✅ and giving it a Like 👍 – it helps others in the community too.
Thanks,
Connect with me on:
LinkedIn |
Data With Pankaj - YouTube
InsightsByV
Super User
Super UserHi,
As Data is coming from Sharepoint location, try Date Modified for configuring Inremental refresh. Using this column will make sure that the changes inside the Excel are taken up during refresh.