Forum Discussion

Morallis's avatar
Morallis
Frequent Visitor
2 years ago
Solved

Dataflow Refresh Failure

Hi,    We have 3 different SQL servers in different environments that we're getting data from using the on-premise gateway. Two of these are working fine, however all dataflows that link to the th...
Dataflows
Need Help
  • Morallis's avatar
    Morallis
    2 years ago

    Issue turned out to be a degraded line with the upstream internet provider.

    This was causing intermittent drops and unusual behaviour.

Morallis's avatar
Morallis
Frequent Visitor
2 years ago

Hi v-cboorla-msft,

 

Thanks I have tried what you recommended, however this is related the the dataflow refresh, which runs on a schedule as well and fails with this too. So it's not related to the machine I'm working from.

 

I have looked at this from the remote server I'm connecting to over the on-prem gateway and have the same result there.

 

I've also created a completely new Dataflow and am having the same result.

The dataset that is being returned is very small and would complete in less than 1 minute.

The refresh now runs for 5 minute and 30 seconds and then fails.

 

The latest failure message is:
Error: AzureBlobs failed to get the response: 'The request was aborted: The request was canceled.

  • v-cboorla-msft's avatar
    v-cboorla-msft
    Microsoft Employee
    2 years ago

    Hi Morallis 

     

    Can you please share me the screenshots of the error that you are encountering in dataflow, in order to understand your query and guide you in a better way.

     

    Thank you.