Forum Discussion

JHob's avatar
JHob
Icon for Advocate I rankAdvocate 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
      Icon for Advocate II rankAdvocate II
      5 years ago

      Same issue for me too. Very frustrating.

  • nickyvv's avatar
    nickyvv
    Icon for Most Valuable Professional rankMost 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
    Icon for Advocate I rankAdvocate 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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi JHob ,

     

    Troubleshooting dataflow issues - connection to the data source | Microsoft Docs

     

    Did you change the type of data source connected? The data source used in the Power Query editor in Power BI Desktop here is different from the one in the configure connection. If so, it is best to make sure that the configuration and credentials used in the front and back ends are the same.

     

    Best  Regards,

    Yuna