Forum Discussion

arimoldi's avatar
arimoldi
Resolver II
3 years ago
Solved

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

  • 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