Forum Discussion

Gabry's avatar
Gabry
Super User
1 year ago

Sporadic Gateway Error (Mashup error) Dataflow

Hi everyone, I'm encountering a sporadic issue with one of my Power BI Dataflows, and I'm hoping someone can shed some light on it. Below is the error message I receive:   Error: Encountered u...
Need Help
lbendlin's avatar
lbendlin
Super User
1 year ago

Could network corruption play a role? Where is the data source in relation to the gateway, what is the latency?

Gabry's avatar
Gabry
Super User
1 year ago

It could be yeah but I don't know how tò check.

The source Is a SQL server, the gateway Is on the same machine of the SQL server. How can I check latency?

If it's a network issue why the data flow Just doesn't try again when It fails, automatically

  • lbendlin's avatar
    lbendlin
    Super User
    1 year ago
    The source Is a SQL server, the gateway Is on the same machine of the SQL server.

    Wait what?!?! Why?!?

     

    There's no latency but there will be a bitter fight for resources.  Don't do that.

    • Gabry's avatar
      Gabry
      Super User
      1 year ago

      Why? What's wrong? I usually build this setup with no issue. I do the etl during night hours.

      What should I do instead?

      • lbendlin's avatar
        lbendlin
        Super User
        1 year ago

        Gateway VMs need to be dedicated to just the gateway service. It is designed to consume all the CPU and all the memory on that VM. As well as all the network for DQ. 

         

        You are supposed to have multiple VMs per gateway anyway.