Report not refreshing due to the Power Query Data errors, but works after I refresh the preview data

[Anonymous]

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 multible tables that are showing errors when I go to the Power Query editor, usually stemming from the Sample File/s.

When I refresh all the previews in the Power Query Editor, the Report refreshes correctly and updates fine.

Pictures below in the replies for context

Why is this happening and how do I prevent this? I would like for the previews to update automatically so I can eventually enable the Power BI online automatic scheduled refreshes.

Thanks

[AnisAloyseNaim]

I have the same issue but my load in powerBI service is "working"

I will test the one parrallel load option 

Thank you

Sometimes i discover that my review loads are not available anymore

(look at the crzay date right bottom corner!!)

[Anonymous]

[negi007 · Accepted solution]

@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

[negi007]

@Anonymous 

this seems to be a data conversion error. Since powerquery does not download the full data so may not be able to face the error in the powerquery but after the full data is loaded then this error might be occuring. Please check if your date and numeric column has any non-date or non-numeric values which causing this error to appear. You could remove auto conversion from value to date  in the powerquery and try to do in the powerbi desktop. 

also refrer to below links for some guidence. 

https://docs.microsoft.com/en-us/power-bi/connect-data/refresh-troubleshooting-refresh-scenarios#:~:text=of%20your%20credentials.-,Data%20refresh%20failure%20because%20of%20password%20change%20or%20expired%20credentials,an%20update%20of%20your%20credentials

[HotChilli]

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

[Anonymous]

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