Managing data refresh from multiple files located on Sharepoint

Hi, KGBOR 

If the file is stored on OneDrive, or SharePoint Online, and the same file is overwritten each day, as opposed to a new file with a different name being created each day, you can connect to that file in Power BI. Your dataset that connects to the file will be synchronized soon after the file on OneDrive, or SharePoint Online, is updated. Any visualizations based on the dataset are automatically updated too.

Daily exported files with different names like you described may not be refreshed automatically.

Please refer to the following links.

https://docs.microsoft.com/en-us/power-bi/connect-data/refresh-csv-file-onedrive 

https://docs.microsoft.com/en-us/power-bi/connect-data/refresh-data 

Best Regards,

Community Support Team _Charlotte

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