Just want to know if the report upload to the PBIRS could refresh with the datasource of excel on sharepoint?
I checked it on the offical website and found the refresh plan could not be scheduled and also could not be authorized with the sharepoint file.
From on-premise Power BI Rerport server, you CAN refresh excel files (or any else), only from on-premise SharePoint Server.
From on-premise Power BI Rerport server, you currently CAN NOT refresh excel files (or any else), from cloud SharePoint Online (due to autentification limitations)
Hi, Yes it can be refreshed. We use the Web connector and copy the spreadsheet's link from Sharepoint on premise (remember to remove the [? =web] bit on the end of the url).
I changed the datasource by your method, but it still can not work.
I also used basic authentication with my organizational account and try to login, failed too.
Any other problem about what I fillin in this page?
Take a look at the September 2023 Power BI update to learn more.
Join Microsoft Reactor and learn from developers.