Dataflow refresh error

[Anonymous]

Hi everyone, 

I have a powerbi pro subscription, and I have many dataflows and reports from different sources like postgresql, sql server and excel files from the desktop.

Normally, all the dataflows were being refreshed properly on a daily basis. But recently all of them just stopped refreshing.

The error message is: 

"Dataflow refresh error "AzureBlobs failed to get the response: 'Unable to connect to the remote server' " 

I have two gateways one is on the local pc another one is on the server. 

I updated the gateways and reinstalled Npgsql-4.0.1.0, but it still is not working.

However, the gateways are functioning when adding new entities and creating new dataflows. The problem is occurring only when  refreshing a dataflow.

[v-eqin-msft]

Hi @Anonymous ,

Sorry to disturb you...

But did I answer your question ? Please mark my reply as solution. Thank you very much.
If not, please upload some insensitive data samples and expected output.

Best Regards,
Eyelyn Qin

[v-eqin-msft]

Hi @Anonymous ,

There’s a couple of possible reasons for this particular variant of the error :

1.Bad network.

2.Gateway version, configuration...

3.Data source location ,permission...

4.No enough memory,CPU...

You may update the gateway to the latest version , Confirm that the data source location has not changed , and re-enter credential when configure gateway in service.

https://docs.microsoft.com/en-us/power-bi/connect-data/refresh-troubleshooting-refresh-scenarios

https://community.powerbi.com/t5/Developer/Unable-to-connect-to-the-remote-server-app-powerbi-com-powerbi/td-p/610902

https://community.powerbi.com/t5/Desktop/Unable-to-connect-Azure-Blob-Storage/td-p/183001

Did I answer your question ? Please mark my reply as solution. Thank you very much.
If not, please upload some insensitive data samples and expected output.

Best Regards,
Eyelyn Qin