Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
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.....
User | Count |
---|---|
127 | |
108 | |
99 | |
63 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |