I used to use office 2016 and I could go to existing connections, select a file dsn and connect via ODBC to JDE iseries to run a query. Now on ProPlus, the file dsn no longer work, so I set up all the connections again and they are stored in "PowerBI style" with "Global Permissions" but I cannot see any connections in user dsn, or file dsn, or system dsn, so every time I want to reuse the connection, I have to create the dsn all over again.
If I go to Get Data, Data Source Settings, I can see all of the connections when the "Global permissions" checkbox is ticked but I can't figure out how to reuse the connection in a new query and it's driving me crazy.
Any help appreciated!
If I go to Get Data, Data Source Settings, I can see all of the connections when the "Global permissions" checkbox is ticked but I can't figure out how to reuse the connection in a new query and it's driving me crazy.
Any help appreciated!