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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Jaffa
Frequent Visitor

Error on refreshing - 'Microsoft.Mashup.OleDb.1' not registered.

I have a workbook with Power Query data from an Azure DB imported into the data model. The workbook was created with a 2.25 version of Power Query. I have updated (and reinstalled) Power Query to the latest version (2.26.4128.242) and resaved the workbook. The workbook is saved on OneDrive for Business. Any time I try to refresh the dataset that has been imported, I get the error:

 

The provider 'Microsoft.Mashup.OleDb.1' is not registered. The following system error occurred: Class not registered

 

Along with a list of all my connections and how they are all failing. I also tried to load the data as an Excel workbook in Power BI, that won't refresh either, but the error is less helpful, just that one of my queries failed to refresh.

1 ACCEPTED SOLUTION
Jaffa
Frequent Visitor

Could the problem be that one of my sources of data is a table in teh workbook itself? I am using a parameter table as shown here:

 

http://blog.oraylis.de/2013/05/using-dynamic-parameter-values-in-power-query-queries/

 

I may build that into a separate query instead, I don't think it has to be in the workbook. Hopefully that will work.

View solution in original post

3 REPLIES 3
curth
Power BI Team
Power BI Team

Can you uninstall and reinstall Power Query to see if that resolves the issue?

Jaffa
Frequent Visitor

Thank you, but it turned out that the problem was that I was using an Excel table as a source for all of my power queries, and that is not supported. Instead I used a query to give me CURRENT_USER in an Azure DB and I can then filter the results of my other queries based on that. I believe I will then be able to save the same spreadsheet multiple times and use Power BI to refresh each under a different user, thus meaning I can give my field force an individual dashboard wghile only having to maintain one workbook.

Jaffa
Frequent Visitor

Could the problem be that one of my sources of data is a table in teh workbook itself? I am using a parameter table as shown here:

 

http://blog.oraylis.de/2013/05/using-dynamic-parameter-values-in-power-query-queries/

 

I may build that into a separate query instead, I don't think it has to be in the workbook. Hopefully that will work.

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

AugPowerBI_Carousel

Power BI Monthly Update - August 2024

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

August Carousel

Fabric Community Update - August 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors