Skip to main content
cancel
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

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

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

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.