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.
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:
But it has no mention of what the Sharepoint admin can do (and I think it is for on-prem only)
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.
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.
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."
Both options should work, according to the May update relaese notes.
I can't get it to work though (same error as topic starter).
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!
130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.