Greetings,
I'm running into a roadblock attempting to add an ODBC data source via Power BI Service via +New / Data sources page from the following URL. https://app.powerbi.com/groups/me/gateways
Here are a few facts:
- The ODBC driver (for Sage 100) is 64-bit and on a workstation that contains Power BI Gateway (July 2022). On the debug tab of the ODBC Manager, the test is successful: Connection succeeded. Datasource includes xxxx tables.
- The Gateway passes the network test. Its status is online.
- From Power BI Service (New), if I purposely mistype the DSN name (system DNS, not user DSN) I receive the following message (expected result). ODBC: ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified. Note: This helps illustrate that Power BI Service is able to communicate with the driver:.
- If I provide the correct DSN, I received the following error: ODBC: ERROR [S0000] [ProvideX][ODBC Driver][PVKIO]Logon failed
ERROR [S0000] [ProvideX][ODBC Driver][PVKIO]Logon failed. - I've tried several variations with/without credentials embedded in the DSN string; always with the same result.
- From the workstation that contains the Gateway, I can successfully use Power Query in Excel locally to use the same DSN I am attempting to use in Power BI Service and it works fine.
- The network firewall was temporarily disabled; same results.
Does anyone have any suggested troubleshooting steps?