Skip to main content
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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

Memorable Member
Memorable Member

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)

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

Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors