Forum Discussion
Change data source from ODBC to MySQL
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
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.
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.
