Refresh with datasource of the excel on sharepoint

[Kratos1112]

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.

[josef78]

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)

[CDavies]

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).

[Kratos1112]

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?