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.

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

Hi Morallis 

 

Thanks for using Microsoft Fabric Community.

Can you please confirm the on-premise gateway version that you are using?

 

Thank you.

  • Morallis's avatar
    Morallis
    Frequent Visitor
    2 years ago

    hi, 

     

    Version 3000.222.5

     

    Something I didn't mention in my original post, is that I am able to setup new dataflows linked to the SQL server without issue.

    When in the Power Query editor creating the Dataflow, i am able to refresh and see the data. Once this is saved and the Dataflow itself is refreshed, this is when it fails.

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

      Hi Morallis 

       

      Thanks for sharing the details.

       

      There might be a chance of an intermittent issue could you please follow the below steps that might help you.

      Temporary Glitch: Clearing cookies and caches can sometimes resolve temporary glitches within the application that might be causing the issue.

      Corrupted Data: In rare cases, corrupted data stored in the browser's cache related to Microsoft Fabric might be causing the issue. Clearing the cache removes this potentially problematic data.

      Hard Refresh: A hard refresh bypasses the cached version of the webpage and forces the browser to download the latest version from the server. Press Ctrl+Shift+R (Windows) or Cmd+Shift+R (Mac).

      Try Microsoft Edge: If you are currently using Chrome or Firefox, try switching to Microsoft Edge to see if the issue persists. Edge is the native browser for Microsoft products and might have better compatibility with Microsoft Fabric.

       

      If the issue still persists, please do let us know. Glad to help.

       

      I hope this information helps.

       

      Thank you.