We have a dataset using Sharepoint online as a datasource and started getting a refresh failed error message when put on the service. Message reads...
SharePoint: Request failed: The remote server returned an error: (500) Internal Server Error. (An error occurred while processing this request.). The exception was raised by the IDataReader interface. Please review the error message and provider documentation for further information and corrective action. Table: BACKUPnew.
I had thought it was related to the note on Support page saying there was an issue when using Premium Capacity and Sharepoint Online datasources. But workaround of removing workspace from Premium Capacity has not helped so wondering if my problem lies elsewhere.
Anyone experienced of this type of error, what was problem/solution? I should add that it refreshes fine from the desktop.
Can you please share more detailed error messages(e.g. request id, activities id... you can find them in refresh history detail info) so that we can use its id to trace detailed error message form power bi service? It will help to troubleshoot.
In addition, did your report host in a premium capacity? If this is a case, please also check the support page known issue list if they suitable for your scenario:
Power BI customers with Premium Capacities using SharePoint Online as a data source may see refresh not complete successfully with the following message - "The underlying connection was closed: An unexpected error occurred on a send". As a temporary workaround until the issue is resolved in Premium capacity, The workspace where the dataset is running can be moved to shared capacity and an on-demand\schedule refresh can be configured. Power BI and SharePoint engineers are actively working on a fix and expect it to be deployed by end-of-day 05/30/2020.
Regards,
Xiaoxin Sheng
Community Support Team _ Xiaoxin If this post helps, please consider accept as solution to help other members find it more quickly.
