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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Advocate II
Advocate II

Service Issue: Excel Online - Error Interacting with workbooks with a Power Pivot Data Model

Hi - Is anyone else experiencing this issue:


Our data is in the North Central US (Illinois) Data Center and since Monday September 6th, our users have been unable to interact (Use a slicer or expand / collapse a Pivot Table) with our Excel Online files in Power BI. These were brought in via the Power BI App > Get Data > OneDrive for Business > Excel Workbook > "Connect" experience, so they use Excel Online. The report renders fine, tabs are navigable, but interaction with any element that uses Power Pivot / Data Model as it's data source produces this error:


Excel Online Sorry Error.png


Excel Online

Sorry, something went wrong.

Could you please try that again?

Give Feedback
Error Id: 467e87b0-0b77-4767-87ce-ff37dbd8088c, 2016-09-08 21:55:35Z


I know there are some performance issues with that Data Center on slow report updating, but no note about Excel Online. The issue occurs with files ranging from 1 MB to 225 MB has has been essentially flawless since early this year. We have also noted that this affects Excel Online Files with Power Pivot Data Model outside of the Power BI Service (SharePoint / SharePoint Online)


I have opened a ticket with Microsoft, but as usual, it is excrutiatingly painful to explain this to technician after technician as most have a very poor understanding of the product in general.


*Note that we still use this Excel Online experience to overcome key limitations of the Power BI Matrix Visualization Smiley Frustrated




Final update -


I have been notified by Microsoft Support and have confirmed that the interaction of Excel Online files with a Power Pivot Data Model in them has returned to normal.



View solution in original post

Frequent Visitor

Same issue with some of my clients reports which worked without problems the last year. At least the issue seems to be a general one. I do hope for a quick fix.

Hi Everyone,


I did receive this note from Microsoft Support yesterday afternoon, so hopefully this get remedied. Note that I forwarded them this message thread to highlight the fact that my case was not the only one!





Sent: September 13, 2016 12:35 PM

Subject: RE:  Excel Online Reports are issuing an error when users interact with the report


You’re correct, and it looks like the issue is specific to the US-NORTH-CENTRAL cluster. We have a couple of other cases where we are seeing the same behavior in Power BI. We have reported them all up to the Product Group and have the Full Fidelity Excel team working towards resolving this issue.

Thanks again for your time and patience. I will let you know when we have any more updates!

Best Regards,


Another update:


Sent: September-15-16 3:45 PM
Cc: MSSolve Case Email <>
Subject: RE: Excel Online Reports are issuing an error when users interact with the report


Hey David,


Quick update, the Product Group was able to identify the issue and it turns out you were right, this ended up being an Excel issue. Based on the information I am seeing, the Excel Online team knowns where the issue is occurring and is now looking at how to resolve it!


Let me know if you have any questions or concerns. Thanks again for your time and patience!

Final update -


I have been notified by Microsoft Support and have confirmed that the interaction of Excel Online files with a Power Pivot Data Model in them has returned to normal.



Thanks for the update and for hanging through the support "experience". I had also opened a case, but a week later and 4 calls afterwards, I only have an initial contact mail from the technician. No updates, no nothing, although after every daily call I was reassured, that someone would get in touch with me by the end of the day...

Support "experience" aside, our slicers are working again since friday! Your ticket seems to have made it through to the right people/team.

Helper I
Helper I

This morning I received several complaints from my customers saying they could not interact with their report. The minute they select a slicer I get the same error as in the first post. Please Help!!

Advocate I
Advocate I



I am seeing the same issue with several Excel workbook reports that have been working fine for us for over a year.  The problems with the data slicer were first reported to me on 9/6.


I am also seeing scheduled refresh problems with the same files.  Those problems started on 9/1 and the reports had been updating just fine for the past year.


I have done some small experiments to try to isolate what might be causing the problems.  The test file data model uses OData and on-prem SQL server data sources via Power Query.  The files have one sheet with a pivot table and slicer tied to the pivot table which works just fine and refreshes fine as long as I don't add a data slicer using a field from a table in the data model.  However, the data slicer works in Excel Online without generating an error.


In summary:


File 1    Data model sources via Power Query, pivot table w/slicer, refreshes fine, slicer works fine

File 2    Data model sources via Power Query, pivot table w/slicer, additional slicer on second sheet, fails refresh, slicer works fine


I tried removing the slicer from the existing report and it still fails refresh with no useful error information.




Very frustrating.

Helpful resources

Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

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

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors
Top Kudoed Authors