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