Forum Discussion
Error on refreshing - 'Microsoft.Mashup.OleDb.1' not registered.
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.
Power BI TeamCan you uninstall and reinstall Power Query to see if that resolves the issue?
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.