Forum Discussion
Solved
Running the schedule updates to get data from SharePoint lists
Hello everyone, I'm trying to find the best solution to an unfortunate situation here: We created a big report with BI Desktop using SharePoint lists as data source, everything is working fine ...
So I hate to be the bearer of bad news, but Sharepoint Online is listed here as not supported for scheduled refresh. https://docs.microsoft.com/en-us/power-bi/report-server/data-sources
You options are to either:
- manually refresh the report
- build another process which can pull the data to another location (like a local SQL database) which is supported for scheduled refresh
- move the list to on-prem Sharepoint (if you have it)
- move your report to the Power BI Service and use a Data Gateway if you also need data from on-prem
So I hate to be the bearer of bad news, but Sharepoint Online is listed here as not supported for scheduled refresh. https://docs.microsoft.com/en-us/power-bi/report-server/data-sources
You options are to either:
- manually refresh the report
- build another process which can pull the data to another location (like a local SQL database) which is supported for scheduled refresh
- move the list to on-prem Sharepoint (if you have it)
- move your report to the Power BI Service and use a Data Gateway if you also need data from on-prem