Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Did you hear? There's a new SQL AI Developer certification (DP-800). Start preparing now and be one of the first to get certified. Register now

Alan_

Excel data model refresh corrupting the data model

Submitted by Advocate II on ‎06-08-2022 05:38 AM

I refresh a number of excel data models using the power bi service. 

As of this week, after the refresh, the model is broken. The result is the workbook crashes (completely closes excel without any error message) when I either try open power pivot or try to open power query on a workbook that has been refreshed via the service. 

Status: Delivered
See more ideas labeled with:
67 Comments (67 New)
Comments
Anonymous
Not applicable
‎06-16-2022 10:36 AM

Hi @Leione 
Can you please share the case number you have with microsoft support?

Leione
Frequent Visitor
‎06-16-2022 11:19 AM

@Anonymous  Case #:31453561

Leione
Frequent Visitor
‎06-16-2022 07:06 PM

There’s an update on this ticket from ms support team. And I also see the alert in MS365 admin center in service health

 

<Analysis>

 

We just got confirmation from internal team that the root cause is “AS Engine added new XML properties into the XML Vertipaq information of the database. Those properties are not compatible with other AS Engine.”

 

<Solution>

 

The fix is available and will be deployed to all regions by the end of June 2022. You could try to refresh it again in early July to verify if the same issue occurs again.

MattyH
Frequent Visitor
‎06-16-2022 07:50 PM

Thanks @Leione  for posting info on this, really appreciate it.

 

I have been stressing out over this problem for weeks now trying to figure out what is going on and it looks as though its getting fixed. 

Anonymous
Not applicable
‎06-17-2022 02:41 AM

Hi @Alan_ ,

 

We have reproduced your issue and have submitted to internal icm 314179254, engineers are doing their best to fix this issue . The ETA for fix is the end of June.

Please be patient and I will give you feedback here once there is any progress.

 

Best Regards,
Community Support Team _ Caitlyn

Anonymous
Not applicable
‎06-17-2022 03:18 AM

I just want to thank you all for:

 

1) having this thread in the first place.

2) sharing your experiences

3) working together to get our voice heard on this issue

 

I was seriously thinking this was not going to get fixed anytime soon and we would all be sitting here with no resolution.

 

Pointing Microsoft to this thread that had the exact same situation I was experiencing as well as providing feedback on my end I think really made a difference to get a solution done.

 

Well done everyone!

JayVee
Frequent Visitor
‎06-20-2022 08:55 AM

Just a follow through to this topic which seems almost closed, but may have a bigger scope than what is being shown here. And also to build on what was mentioned by @MattyH:

 

This issue does not only affect the Excel files refreshed by the PowerBI Service. In fact it affects any Excel file refreshed by any MS Online Service which uses the AS Engine. In my company it is happening with several Excel files that are stored in SharePoint Online and that are not at all connected to the PowerBI Service.

 

The crash situation is exactly the same: once the user uploads the file to the SharePoint Online and try to use the Excel Online option to refrsh the data model, the file is corrupted and instantly crashes when doing anything with the data model in Excel Desktop. No warning, no error message, just a direct crash.

 

On top of that, I opened the XML file pointed by the Event Viewer log as the cause of issue and here we can see clearly that it was created/updated on the 2nd of June (date where the issue started as reported by many users):

 

<CreatedTimestamp>2022-06-02T09:13:56.64</CreatedTimestamp>
<LastSchemaUpdate>2022-06-17T07:17:46.256667</LastSchemaUpdate>

 

Also, coincidently or not, the 17th of June (last Friday) was when the issue started to affect our users.

 

Hopefully Microsoft will roll out the updates not only for PowerBI users but for all users of the AS Engine, in whichever app it may be.

Anonymous
Not applicable
‎06-20-2022 10:02 AM

@JayVee  - Interesting as I typically do not refresh data in Excel Online at all so I never tried.  So after reading your post I tried it myself.  What happens for me is that as soon as I choose "Refresh All Connections" is that it starts to refresh, but it puts the report in a perpetual "Saving..." state and the refresh never seem to finish.

 

I'm assuming it will have the same behavior as you describe if I was paitient enought to let he refresh finish. 😃

 

Great find though.

RosaVB
Regular Visitor
‎06-21-2022 03:33 AM

Thank you very much @Leione for sharing the resolution you have achieved, in my case the technical department of BI did not solve anything and they are still going round in circles without any sense.
Let's see if they soon fix this big problem with excel updates.

Anonymous
Not applicable
‎06-22-2022 06:22 PM

I also encounter the same issue, does anyone know any workaround for this? I have tried to refresh in Excel Online, but it never finished.

Idea Statuses