Forum Discussion

JHob's avatar
JHob
Advocate I
5 years ago
Solved

Power BI Dataflow Connection issue

Hi

 

Is anyone experiencing issues with Power BI Dataflows.  I am getting the following error when I try and edit any of the queries.

 

 

This is happening in Power BI Dataflows that I have a gateway setup for a MySQL database, as well as a gateway for a PostGreSQL database

Need Help
  • JHob's avatar
    JHob
    5 years ago

    Thanks Nicky

     

    I found out that I needed 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

7 Replies

  • tonylee's avatar
    tonylee
    Frequent Visitor
    5 years ago

    I am also experiencing this problem - I have dataflows that have worked for months. They are clearly still working and the scheduled and on-demand refreshes occur perfectly. But when I go into edit them I get the configure connection error. I have been through the workaround to re-hookup the gateway and reenter my credentials and all is good, and I can work on the flow. But when I save and go back into edit I have to go through the workaround again. So not a practical ongoing workaround. I'm glad that it appears not only to be me!

    • PaulKn's avatar
      PaulKn
      Advocate II
      5 years ago

      Same issue for me too. Very frustrating.

  • nickyvv's avatar
    nickyvv
    Most Valuable Professional
    5 years ago

    Hi JHob,

    and what happens/which error do you see when you click on Configure connection?

    Remember that PQ is case-sensitive, so make sure to use the proper case of the connection (server + database).

  • JHob's avatar
    JHob
    Advocate I
    5 years ago

    Thanks Nicky

     

    I found out that I needed 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

  • David2021's avatar
    David2021
    New Member
    5 years ago

    I have the same problem, please, if you solve the problem, let us know.