Forum Discussion

NaGer's avatar
NaGer
Frequent Visitor
3 years ago

Power BI Service ODBC Unable to create Data source

Have a problem with the creation of datasource in Power BI Service. Can't add to gateway. ODBC driver installed on System. On desktop app everything works, but I need to set the scheduled refresh in...
Need Help
djurecic's avatar
djurecic
Icon for Super User rankSuper User
3 years ago

Hi NaGer ,

 I think you may need to create an ODBC connection to the datasource on the machine that the gateway is installed on, not just install the driver. Error IM002 means that the data source name is not found:

https://community.microfocus.com/adtd/silktest/w/wikiid-128/10036/how-do-i-resolve-error-im002-microsoft-odbc-driver-manager-data-source-name-not-found-and-no-default-driver-specified#:~:text=This%20error%20is%20typically%20thrown,DSN%20that%20does%20not%20exist.&text=The%20DSN%20must%20already%20exist,DSN%20that%20has%20been%20created.