I setup a new Excel workbook in PowerBI that uses PowerPivot. When I tried to refresh the workbook, it failed with this error:
Refresh on demand failure
Correlation ID: df9ca87f-8834-49b7-8159-320bc4d948a8
The following system error occurred: Class not registered The provider 'MSOLAP' is not registered.
How do I fix this?
Have you created the new workbook on the same machine or on a different one? On creation you have been able to fetch the data from the source (by provider MSOLAP I guess from SSAS)?
You could try to reinstall the MSOLAP provider, you can get it from
SQL Server Feature Pack => ENU\x64 or x86\SQL_AS_ADOMD.msi
Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.
Would you like to participate?