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 an...
I was just about to open a ticket with Microsoft when I saw this post. I tracked my issue back to June 2nd. That is, any Excel files that was refreshed by the Power BI Service after June 2nd has a corrupt data model. Simply trying to queries pane will result in Excel crashing entirely. I did find that the Windows Event Viewer is registering the error as:
The description for Event ID 39 from source MSOLAP$LocalCube cannot be found. Either the component that raises this event is not installed on your local computer or the installation is corrupted. You can install or repair the component on the local computer.
If the event originated on another computer, the display information had to be saved with the event.
The following information was included with the event:
An unexpected exception occurred.
The message resource is present but the message was not found in the message table
I tried to restore files from backup, but as soon as Power BI refreshes the data model, the problem returns.
This is a big problem for us, and we would be very interested in finding out what is causing this and what the solution is. Thanks.