Forum Discussion

MirceaFlorea's avatar
MirceaFlorea
New Member
6 years ago
Solved

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...
Need Help
v-xicai's avatar
v-xicai
Community Support
6 years ago

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-p/23448.

 

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's avatar
    Anonymous
    Not applicable
    3 years ago

    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