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
MirceaFlorea
New Member

Error when doing data refresh

Hello, 

 

I get the following error when clicking Refresh for a PowerBI report from a SharePoint 2013 library: 

 

OLE DB or ODBC error: [DataSource.Error]. An error was read from the payload. See the 'Error' property for more details. 

 

I don't know what's generating this error or where I could check the 'Error' property for more details. 

 

Can you help me?

Thank you

1 ACCEPTED SOLUTION
v-xicai
Community Support
Community Support

Hi @MirceaFlorea ,

 

You may go to File->Options and Settings->Data Source Settings->Global permissions in Power BI Desktop, find the data source stored SharePoint,  click "Edit permissions", then click "Edit", choose organizational account method (or Microsoft account) to sign in the appropriate credential.

 

or click "clear permissions" for stored SharePoint data source, then connect to the data using SharePoint folder connector again, use the URL below and use organizational account method.  See more: Connecting to Files in SharePoint & OneDrive with Power BI / Power Query.

 

https://xxxxx.sharepoint.com/sites/<sitename>

 

There is a similar case you may refer to: https://community.powerbi.com/t5/Power-Query/DataSource-Error-connecting-to-SharePoint-2010-list/td-....

 

Best Regards,

Amy 

 

Community Support Team _ Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

7 REPLIES 7
v-xicai
Community Support
Community Support

Hi @MirceaFlorea ,

 

You may go to File->Options and Settings->Data Source Settings->Global permissions in Power BI Desktop, find the data source stored SharePoint,  click "Edit permissions", then click "Edit", choose organizational account method (or Microsoft account) to sign in the appropriate credential.

 

or click "clear permissions" for stored SharePoint data source, then connect to the data using SharePoint folder connector again, use the URL below and use organizational account method.  See more: Connecting to Files in SharePoint & OneDrive with Power BI / Power Query.

 

https://xxxxx.sharepoint.com/sites/<sitename>

 

There is a similar case you may refer to: https://community.powerbi.com/t5/Power-Query/DataSource-Error-connecting-to-SharePoint-2010-list/td-....

 

Best Regards,

Amy 

 

Community Support Team _ Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous
Not applicable

Hi @MirceaFlorea,
Thanks for the solution. I have an On-Premise SharePoint list and when I change the datasource settings, it throws me this error. I tried your method, it's still throwing the same error. Please let me know what could be the issue.

Ashfiya_Naaz_0-1661512247905.png

Regards,

Ashfiya

Greg_Deckler
Super User
Super User

@MirceaFlorea You could check the Issues forum here:

https://community.powerbi.com/t5/Issues/idb-p/Issues

And if it is not there, then you could post it.

If you have Pro account you could try to open a support ticket. If you have a Pro account it is free. Go to https://support.powerbi.com. Scroll down and click "CREATE SUPPORT TICKET".


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...
amitchandak
Super User
Super User

@MirceaFlorea , check the credential provided

amitchandak
Super User
Super User

@MirceaFlorea .Open Transform data/ Edit query mode

refer how to handle error in power query
https://www.youtube.com/watch?v=OE6DPmKqN7s
https://www.youtube.com/watch?v=9-Lag0VOiTs

FarhanAhmed
Community Champion
Community Champion

Are you refreshing report from Service or Desktop ?

 

Are you extracting list from Sharepoint ? 







Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!

Proud to be a Super User!




From PowerBI desktop 

I'm downloading the report from a SharePoint library, but I'm not sure how the report was made. 

I'm responsible for the SharePoint side and trying to see if it's anything from  SharePoint that's causing this. 

 

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.