Forum Discussion
Dynamic ODBC source selection in Power Query
Hi. I know how to parametise dsn names in Power Query, so they can be switched easier... I'm wondering if more is possible. I have an Excel file that is used by multiple people and I'd like to to s...
emarc1 I had tried it , it doesnt work
sorry one query is from demo2 dsn and the other query is from demo3
one query is successfully working while the other gives an error ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
I dono which and where did i miss
Check it works when you manually change it. Maybe the DSN isn't set up properly in your ODBC driver. Other than that, I'm not sure I can help as I'm really not an expert either! Try making a new thread for it and someone more experienced may be able to help.
