cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
nathanbonobobi Frequent Visitor
Frequent Visitor

Add odbc data source to On-Premises Gateway throws IM003 Access is denied to driver DLL

Hi,


My gateway does not have access to my odbc driver. How do i grant access?

 

In my Power Bi Service I have installed "On-Premises Data Gateway" (not personal mode)

I want to add to the gateway a known good 64-bit ODBC Data Source System DSN "x".

In https://app.powerbi.com/ select cog icon then "Manage Gateways"
then select gateway cluster (which has status "Online: Your are good to go.")
then link "Add data sources to use the gateway"
Data Soure Type ODBC
Connection String dsn=x
authentication method basic
privacy level Organizational (default)

when i click "Add" system throws error


Unable to connect: We encountered an error while trying to connect to . Details: "We could not register this data source for any gateway instances within this cluster. Please find more details below about specific errors for each gateway instance."Hide details
Activity ID: 1e3a68dc-7399-4edf-ba28-a894f21980b1
Request ID: 45231e63-f695-6e81-d9a9-b277478f00a2
Cluster URI: https://wabi-uk-south-redirect.analysis.windows.net
Status code: 400
Error Code: DMTS_PublishDatasourceToClusterErrorCode
Time: Tue Dec 11 2018 15:02:24 GMT+0000 (GMT Standard Time)
Version: 13.0.7611.194

datagateway: Cannot connect to the mashup data source. See error details for more information.
Underlying error code: -2147467259
Underlying error message: ODBC: ERROR [IM003] Specified driver could not be loaded due to system error 5: Access is denied. (Oracle BI Server-bic_1, C:\app\oracle\product\12.2.1\bic_1\bi\bifoundation\server\bin\NQSODBC64.dll).
DM_ErrorDetailNameCode_UnderlyingHResult: -2147467259
Microsoft.Data.Mashup.ValueError.DataSourceKind: Odbc
Microsoft.Data.Mashup.ValueError.DataSourcePath: dsn=x
Microsoft.Data.Mashup.ValueError.Reason: DataSource.Error

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
nathanbonobobi Frequent Visitor
Frequent Visitor

Re: Add odbc data source to On-Premises Gateway throws IM003 Access is denied to driver DLL

I solved it using the following troubleshooting guide

https://docs.microsoft.com/en-us/power-bi/service-gateway-proxy#changing-the-gateway-service-account...

 

start run services

then for on-premises data gateway service

on the tab log on changed the user to use

Local Service Account
Y=Allow service to interact with desktop

 

then recovered the gateway using the recovery key

Sorted! 

1 REPLY 1
nathanbonobobi Frequent Visitor
Frequent Visitor

Re: Add odbc data source to On-Premises Gateway throws IM003 Access is denied to driver DLL

I solved it using the following troubleshooting guide

https://docs.microsoft.com/en-us/power-bi/service-gateway-proxy#changing-the-gateway-service-account...

 

start run services

then for on-premises data gateway service

on the tab log on changed the user to use

Local Service Account
Y=Allow service to interact with desktop

 

then recovered the gateway using the recovery key

Sorted!