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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
paopau86
New Member

OLE DB or ODBC error connection with sharepoint

We have an excel file that is stored on Sharepoint and it is a source for a PowerBI report. After the July Windows update, the connection between these files started producing errors, see attached. 

We already reviewed the tables and they are fine, even imported them from a local source and OneDrive and the tables import just fine. There is an issue with the connection with Sharepoint but cannot figure out how to fix it. We already installed a new version of the Access OLEDB/ODBC Redistributable suggested in other posts and still does not work. I am on Version 10.0.16299 Build 16299 of Windows 10 64-bit, and it was right after this update that these errors started appearing.

 

Please let me know if there is any remedy or workaround for this issue.

 

Thank you!

PowerBI error.PNG

4 REPLIES 4
Anonymous
Not applicable

Hi,

I had the same issue last month and with the help of below steps my sharepoint connections is working,

Step 1:Go to File-Options and Setting—Data Source Setting

Step 2:In Data Source Setting you will see SHAREPOINT Connections “http”

Step 3 :Select that http and click on Edit Permission

Step 4: your Credential and Privacy Level should be below

Thanks

COMMUNITYPICTURE.jpg

Anonymous
Not applicable

Thank you so much! We already tried these solutions with no success. The error keeps popping up.

Anonymous
Not applicable

hi @paopau86  

Please raise a support ticket on power BI indicating your issue.

https://powerbi.microsoft.com/en-us/support/

They will do an internal trace as what's happening and will advise on a solution. also make sure your sharepoint file columns are in right data type which can lead to errors similar.

Thank you.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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