Forum Discussion
Running the schedule updates to get data from SharePoint lists
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
Thanks d_gosbell for the answer.
Manually updating the report like "open the desktop version and click update" would probably not be enough, we're looking for something the user can open this report online and it just works.
I was wondering: would it be possible to use Power Automate to export the SharePoint lists as an Excel file (as .xls) and store it in OneDrive and then use Report Server to update the reports using those new files in OneDrive? Is there something I'm missing that might make this not work?
I can change the connections in BI to the new files without much problem, right?
Thanks!
Gilmar-Neto wrote:
I was wondering: would it be possible to use Power Automate to export the SharePoint lists as an Excel file (as .xls) and store it in OneDrive and then use Report Server to update the reports using those new files in OneDrive? Is there something I'm missing that might make this not work?
Nope. It's not so much the data location that is the issue, its the AzureAD/OAuth2 authentication that is the problem. OneDrive uses the same authentication as Sharepoint Online so its not supported for scheduled refresh either.