changing data source without changing the set visualization and tables cleansed

[Anonymous]

Hi All, is there any possible way to change the data source of a report I have created using ODBC connection to the MySQL database server.  As you can see in the picture the connection is DSN and graphdata is the name of the ODBC connection and I have to shift that to MySQL server. Please help. If I'm trying to change it manually in the Source it is howing access denied, but the rproblem is it is not asking for password, so Don't know how to proceed. Please help 

[Greg_Deckler]

Create a query that connects to your new source. Use Advanced Editor to copy the Source and possibly Navigation lines. Go to your old query and open Advanced Editor. Replace the lines in that query with your copied ones.

[Anonymous]

Hi Greg, tried with adv query as suggested by you. Earlier was going with direct changes in the Applied Steps> Source. Still didn't workout. I got the error ODBC: ERROR [HY000] [MySQL] [ODBC 8.0(a) Driver] Access Denied for user 'root'@'10.....