Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
The problem is known around this forum for the personal gateway connection between Data sources in Power BI Service and Power BI Desktop when refreshing the data:
"Excel Workbook: The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine.
The 64-bit version of the Access Database Engine 2010 Access Database Engine OLEDB provider may be required to read this type of file."
Yet, I tried everything I found here: Installing/Reinstalling the Access Database Engine 2010 Access Database Engine; Changing the file location from Companys' Sharepoint to personal OneDrive for Business; Changing the Excel extension from .xlsb to .xlsm; updating credentials; but the error still strikes everytime.
I know that I can get a work around - creating a macro / using flow - to save a .csv or .xlsx file (without connection/macros) everytime I run an update, but I wanted to know the problem and if it has a specific solution to solve it!
Additional information:
Thank you in advance!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.