Forum Discussion

David2021's avatar
David2021
New Member
5 years ago

Power BI Dataflow Connection Issues with Gateway (On Premise)

Hi all,

Since February 12th, I have been experienced this error:

Suddenly the dataflows connected to the Gateway miss the conection. So, when I go into the dataflow to edit the query, I started to receive a configuration error and gateway is missing:

 

However, I'm able to add a new query with the gateway connection for the ODC I'm using, so I can say that the connection to the gateway is not the problem.

Workaround:

When I need to edit the query, i have to reselect the gateway under Options and Project Options in order for it to connect. However evertime I save the dataflow and then reopen it I have the same situation and need to reselect Options and Project Options.

Please your advice.

PD:

The refresh of the gateways are just fine, I don´t have problems with that.

 

Dataflow
Need Help

5 Replies

  • germanpp's avatar
    germanpp
    Frequent Visitor
    5 years ago

    Apparently this is a known issue, and will be corrected soon. I had the same problem, I needed to edit a query that was preventing the dataflow refresh, but could not save changes as all queries showed a "please specify how to connect" error and would not let me configure the connection. Fortunately after a while I found the same workaround you mention...  I was opening a support ticket and saw this message in the support page -> "Power BI customers editing existing dataflows that use the on-premises gateway client may see the message, "Please specify how to connect". Any changes made will not be saved. Engineers have identified the root cause and a fix is expected to be deployed by end-of-day 02/22/2021"