ApiRequest Error with Status 0

[PowerBi_errors]

Hey, 

I have a dataflow that is pulling from an sql server but the dataflow keeps failing to refresh. This is the error when I click into the dataflow:

---------- Message ----------
ApiRequest error with status 0

---------- Stack ----------
ApiResponseError: ApiRequest error with status 0
at p.handleErrorEvent (https://us.prod.powerquery.microsoft.com/MashupEditor/scripts/p.h.a.7c9e0dcb915f3ca78238.bundle.js:2...)
at XMLHttpRequest.<anonymous> (https://us.prod.powerquery.microsoft.com/MashupEditor/scripts/p.h.a.7c9e0dcb915f3ca78238.bundle.js:2...)

---------- Session ID ----------
fcb06586-d4ec-461b-a96a-f91e46ccddd9

---------- Request ID ----------
776131fc-68af-4088-8b15-2bb9a27f28bb

[Anonymous]

Hi @PowerBi_errors ,

The "ApiRequest error with status 0" error you're encountering in your dataflow refresh could be caused by various issues, such as network connectivity problems, server-side issues, or issues with the data source itself. To troubleshoot this issue, you can try the following steps:

1. Check your network connection and ensure that there are no connectivity issues.
2. Verify that the SQL Server is up and running, and that there are no issues with the server itself.
3. Review the data source configuration in your dataflow to ensure that it is set up correctly.
4. Verify that your data source credential is valid and has the required permissions to access the SQL server.

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.