Forum Discussion
arimoldi
3 years agoResolver II
Error with Sharepoint Excel File
Hi all,
I have developed a simple Power BI dashbaord reading data from a Sharepoint Excel file, connection was fine and data were loaded correctly. When I opened again the pbix file I got this error:
OLE DB or ODBC error: [DataSource.NotFound] 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 OLEDB provider may be required to read this type of file. To download the client software, visit the following site: ...
From Power Query I can see all the updated data (so connection to the file is fine), but I also see a bottom rows with all columns populated with "Error" with the same above error:
Any suggestion?
Thanks,
Andrea
Problem solved... I have saved the pbix file in the same sharepoint folder of the excel and that was causing the problem, after deleting it the dashboard worked as before
1 Reply
- arimoldiResolver II
Problem solved... I have saved the pbix file in the same sharepoint folder of the excel and that was causing the problem, after deleting it the dashboard worked as before