Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

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.

Reply
arimoldi
Resolver I
Resolver I

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:
 
arimoldi_0-1684243434978.png
 
Any suggestion?
 
Thanks,
Andrea
1 ACCEPTED SOLUTION
arimoldi
Resolver I
Resolver I

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

View solution in original post

1 REPLY 1
arimoldi
Resolver I
Resolver I

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

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.