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

Get certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now

Reply
agneum
Helper II
Helper II

Can't refresh Power BI pivot table in Excel Online

When i open the excel workbook from Sharepoint, I get the error "External data source Failed We were unable to refresh one or more data connections in this workbook". I have used Pivot table referring to the power bi connection and set auto refresh when open the excel. It uses just one connection.

 

error.png

Opening it in desktop works just fine, but I need it to work in the online version. Why is this happening?

The only information I have found is this very old article:

https://support.microsoft.com/en-us/office/refreshing-data-in-a-workbook-in-a-browser-window-8956019...

But it has no mention of what the Sharepoint admin can do (and I think it is for on-prem only)

 

7 REPLIES 7
mwegener
Most Valuable Professional
Most Valuable Professional

Hi @agneum ,

 

you need to load the Excel file into Power BI via SharePoint or OneDrive for Business.

 

01_UploadExcel.png

02_UploadExcel.png

03_UploadExcel.png

04_UploadExcel.png

 

https://www.linkedin.com/posts/activity-6822986449005232128-OFCX

 

Did I answer your question?
Please mark my post as solution, this will also help others.
Please give Kudos for support.

Marcus Wegener works as Full Stack Power BI Engineer at BI or DIE.
His mission is clear: "Get the most out of data, with Power BI."
twitter - LinkedIn - YouTube - website - podcast - Power BI Tutorials


AlexisOlson
Super User
Super User

I'm having this issue too.

 

According to Carlos Otero here: "the Excel for the web feature announced in this post (i.e. Power BI PivotTable refresh and interaction) is now fully rolled out" (as of 8/13/2021), so I'd expect it to be working by now.

It seems that this functionality is released for our en our customers tenants. 🙂

This works perfectly now for us.

greenguy2012
Advocate I
Advocate I

Bumping for visibility as I have the same issue. Any one found a solution?

nbjdeunk
Frequent Visitor

I'm experiencing the same behaviour. Both using 'Analyse in Excel' en starting a blank workbook with a new connection to a PowerBI dataset will result in the same error.

 

This scenario is announced april 2021.

https://techcommunity.microsoft.com/t5/excel-blog/power-bi-connected-pivottables-in-excel-for-the-we...

 

Untill this moment i'm getting the same error as topic starter. As the blog post states, this feature will 'roll out in the comming months'. So probably, we just have to wait?

 

"This new feature has started rolling out across Microsoft 365 tenants, and we expect full roll out over the next few months."

lbendlin
Super User
Super User

This sounds a bit different than "Analyze in Excel"  - have you considered using that instead?

Both options should work, according to the May update relaese notes.

I can't get it to work though (same error as topic starter).

 

https://powerbi.microsoft.com/en-us/blog/power-bi-may-2021-feature-summary/#excel_share_collaborate

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

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

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

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