Error when doing data refresh

[MirceaFlorea]

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

[v-xicai · Accepted solution]

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]

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.

Regards,

Ashfiya

[Greg_Deckler]

@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".

[amitchandak]

@MirceaFlorea , check the credential provided

[amitchandak]

@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]

Are you refreshing report from Service or Desktop ?

Are you extracting list from Sharepoint ? 

[MirceaFlorea]

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.