multiple Data Source instances used in ODBC using the same driver for each instance having issue

[NISHA_S]

Hi all,

      I have create  2 same report using different datasource instance .I have used  Postgresql Unicode ODBC driver classes for both report.I added both datasource in Instances in Same Driver classes with different DSN .Connection everything ok..And i can fetch data on both report using same driver with two datasource instances.But i faced some issue after publishing 2 reports to same service accounts under same gateway..I added one of the datasource under gateway sucessfully .But when i try to added another report datasource under the same gateway, error occured.

But i have no issue while try to fetch data from same database in power bi desktop.If i changed driver class i will get db connection correctly.Why we can't connect multiple datasource instance to same odbc driver classes using enterprise gateway?Plse help?

[lbendlin]

Have you confirmed on all gateway cluster members that your ODBC drivers are installed and the connections are set up and working?

[lbendlin · Accepted solution]

Think of the gateway as a PC running without adult supervision.   You need to exactly replicate the ODBC setup in your PC, including installing the driver and creating (and testing!) the different connections.

[NISHA_S]

that's all i did and am getting connections correctly in power bi desktop.Issue found after publishing these report to power bi service and try to add these datasource to gateway...at that time am getting error

[negi007]

@NISHA_S can you go through below links regarding similar error faced by other users

https://forums.asp.net/t/1932912.aspx?ERROR+IM002+Microsoft+ODBC+Driver+Manager+Data+source+name+not....

https://docs.microsoft.com/en-us/answers/questions/227987/34error-im002-microsoftodbc-driver-manager...