cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Kratos1112
Regular Visitor

Refresh with datasource of the excel on sharepoint

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.

 

data source refresh.JPGdata source.JPG

3 REPLIES 3
josef78
Super User
Super User

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
Resolver I
Resolver I

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?

Connection failed.JPG

Helpful resources

Announcements
PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.