ODBC: ERROR [HY000] INVALID_LOGIN: Invalid usernam...

IssacCDavid · ‎09-21-2022

I am receiveing the below error when trying to set up a dataflow in Power BI web to connect via a gateway to Salesforce

ODBC: ERROR [HY000] INVALID_LOGIN: Invalid username, password, security token; or user locked out.

Details:

DataSourceKind = Odbc

OdbcErrors = #table({"SQLState", "NativeError", "Message"}, {})

The status of the connection is showing up as "Online", but we are unable to connect using the connection from Power BI web to Salesforce to retrieve the value.

I have also verified the credentials used for the Salesforce account used to set up this connection and data source and I am able to login to Salesforce user account using theses credentials.

IssacCDavid · ‎09-28-2022

Hello Caitlyn,

Thank you for the pointers and sorry for not getting back with a response/update in time.

We do not use Security Toke, Consumer key or secret. But rather credentials for a service account/user on Salesforce

Our Power BI Technical team that manages creating the connection/dataflows created a new DSN and tested the credentialls for the Salesforce User/Service Account using CData ODBC connection application and then proceeded to use this new DSN in creating a new Dataflow connection with the credentials

Some observations were:

1. On the Salesforce Service user/Account Record - Ensure that the account is not locked out, credentials are valid and that "API Enabled" access is provided either through the Profile level or through a Permission set

2. This part is not that clear to me, but it appears that multiple dataflows using the same DSN do not work - Please feel free to correct me if this is wrong. We had reconciled to removing any Dataflow connection we were trying to create and had just unique connection in the end, which also seemd to contribute to resolving the issue

Thank you again for your timely response and suggestion