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

[Jaffa]

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.

[curth]

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

[Jaffa]

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 · Accepted solution]

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.