Change data source from ODBC to MySQL

[rogervsclimbing]

None of the Microsoft documentation matches my desktop.  everything says use Edit Query.  This does not exist.  all the documents I find say it's easy' to switch sources...  it is not.

in Transform data I found, data source setting.  but it does not allow me to change.

PowerBI, another Microsoft frustration.  Expensive, no documentation, no support.

[Anonymous]

@rogervsclimbing 

Edit Query is changed to Transform Data in the new version. You can only change the credentials in the datasource setting. Is there any thing that restricts you? If not you could just get data from MySQL straightway, there is a My SQL connector in deskop.

Paul Zheng _ Community Support Team
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[aj1973]

Hi @rogervsclimbing 

Your issue is not really clear! Can you send some screen shots?

[rogervsclimbing]

Here is the Microsoft document as of 5/19/20

Here is my app

no Edit Query!

[aj1973]

the second image is the new version of Power BI desktop. if you want to go back to the old version then you need to Uncheck the use of ribbon. here is how 

But if you want to keep the new Version of the desktop then use the Button

Regards

[rogervsclimbing]

Thank you for the explanation to put (or return) Edit Queries to the menu bar.  but, as I now see, it just leads to the same Edit Data Sources... in which there are no additional choices, just the existing ODBC connector.  if i click on Global permissions, i can see what i think is the MySQL connector, but there is nothing here that allows me to select that as the data source.... just edit its permission.

yes, I have the latest MySQL/.net connector installed.

the root issue is the gateway.  we are new to PowerBI.  the gateway is full of different connections to the same data, plus, we cannot get the ODBC connections to work on the gateway - well, some work, but because we cannot see the details of the connection, we cannot use elsewhere, but we can get the MySQL connector to work.  whereas on the development workstations, we can get both to work (assuming we use an older version of the .net and ODBC connectors).

the gateway is just a giant support nightmare.  

so, my goal was to edit the reports to all use the same credentials/connectors that are to the same data source.  

[Tahreem24]

What I understood from the query is to change the data source to another data source.

As  found the query editor option under transform data. So open the query editor and go to the Applied steps at the rightmost pane and click on "Source" then by click on it you'll get credentials details on formula so kindly change from there.