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
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.

      • Gabry's avatar
        Gabry
        Super User
        1 year ago

        I'm looking further into your suggestions and I keep investigating the issue, in the meantime, I noticed that I can set up a Power Automate flow to rerun the dataflow in case of failure, so I set this up, and it's working great.