Refresh (Update\Append) with only new CSV file to PowerBi Report

[hsiddiq]

Hi Team,

I currently have PowerBi dashboard setup to load same strucutred csv files from a folder.
daily at 12AM the new File gets added to the folder

Since there are multiple files in the Folder (20+ csv files), is there a way to only update\append the new file which would be more quicker then hitting Refresh and reading all the files again?

Folder path: x:\queuereport

FileName: QueueReportData-ddmmyyyy.csv (ddmmyyyy would be 15012023)

Refresh: Daily 12AM

[Ritaf1983 · Accepted solution]

Hi @hsiddiq 
Unfortunately, there is no option to refresh only the "last file", but you can consider applying an incremental refresh.

Please refer to the linked tutorials:

https://iterationinsights.com/article/how-to-setup-incremental-refresh-in-power-bi/

https://www.datalineo.com/post/power-bi-incremental-refresh-with-binary-files

https://www.youtube.com/watch?v=9WLZ9jfoXwA

 If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly