Forum Discussion

martaredondo's avatar
martaredondo
Icon for Helper II rankHelper II
5 years ago

Sharepoint file - Automatic Refresh not working

Hi all,   I developed a report based on an Excel file from Sharepoint (connector "Web"). I was expecting my data to refresh automatically (like a DirectQuery source) but for some reason it is not. ...
Need Help
mahoneypat's avatar
mahoneypat
Icon for Microsoft Employee rankMicrosoft Employee
5 years ago

That is the default behavior and would be the same if you used the SharePoint Folder connector too.  Scheduled Refresh is the way to go.  Another option would be to make a Flow with Power Automate to trigger dataset refresh whenever a file is added or modified to that SharePoint library.  If there are multiple per hour, I would not recommend that as you will run out of daily refreshes.

Regards,

Pat