Forum Discussion

ascendbi's avatar
ascendbi
Advocate II
9 years ago
Solved

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 exp...
General Comment
Need Help
  • ascendbi's avatar
    ascendbi
    9 years ago

    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.

     

     

bfrancis's avatar
bfrancis
Advocate I
9 years ago

Hi,

 

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.