Forum Discussion
Report not refreshing due to the Power Query Data errors, but works after I refresh the preview data
Hello There, I keep getting errors when I refresh the Power BI Desktop report/Online Report. The errors are due to issues with the sample/appended files in the Power Query Editor. I have mult...
Anonymous
pl. see if turning off paralle loading of tables option help you.
also refer to below links if issue still persists.
https://community.powerbi.com/t5/Power-Query/DataSource-Error-SharePoint-Request-failed/td-p/210387
https://stackoverflow.com/questions/64668224/datasource-error-sharepoint-request-failed
I suppose it depends on the nature of the error but this can happen because the preview only loads 1000 rows so if the error occurs later it won't show in preview
The error shows up in the Report, I go into Power Query Editor to troubleshoot and it shows multiple errors. All I do is click refresh all in power query editor and all the errors are gone in the report and power query editor