Forum Discussion
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
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.
7 Replies
Are you refreshing report from Service or Desktop ?
Are you extracting list from Sharepoint ?
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.
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-Lag0VOiTsMirceaFlorea , check the credential provided
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".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.
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
