Forum Discussion
Why is refresh failing?
Hi - I am fairly new to Power BI so apologies in advance if I'm missing any info! We have connected some tables from Denodo to Power BI and all refreshes were working fine until today - we received the below error:
Data source error{"error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","pbi.error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","parameters":{},"details":[{"code":"DM_ErrorDetailNameCode_UnderlyingErrorCode","detail":{"type":1,"value":"-2147467259"}},{"code":"DM_ErrorDetailNameCode_UnderlyingErrorMessage","detail":{"type":1,"value":"ODBC: ERROR [ ] ERROR: Error executing query. Total time 0.0 seconds.\n\nQUERY [VIRTUAL] [ERROR] \nQUERY [JDBC WRAPPER] [ERROR] \nQUERY [JDBC ROUTE] [CONNECTION_ERROR] Unexpected error creating a connection: Incorrect driver i\njava.sql.SQLException: Error executing query. Total time 0.0 seconds.\n\nQUERY [VIRTUAL] [ERROR] \nQUERY [JDBC WRAPPER] [ERROR] \nQUERY [JDBC ROUTE] [CONNECTION_ERROR] Unexpected error creating a connection: Incorrect driver i;\nError while executing the query"}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ValueError.DataSourceKind","detail":{"type":1,"value":"DenodoForPowerBI"}},{"code":"Microsoft.Data.Mashup.ValueError.DataSourcePath","detail":{"type":1,"value":"{\"DSN\":\"DenodoODBC\"}"}},{"code":"Microsoft.Data.Mashup.ValueError.OdbcErrors","detail":{"type":1,"value":"#table({\"SQLState\", \"NativeError\", \"Message\"}, {})"}},{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"DataSource.Error"}}],"exceptionCulprit":1}}} Table: Shop Managers.
I have tried installing multiple versions of Denodo ODBC drivers and I keep receiving the same error. Any suggestions?
1 Reply
rubayatyasminCommunity Champion
Hi, taylor_8
Based on the error message you've shared, it looks like the problem is related to the ODBC driver or its configuration. Here are several suggestions on how you can troubleshoot this issue:
Confirm the correct ODBC driver is installed: Double check to make sure the correct ODBC driver for Denodo is installed on your machine. Also ensure it matches your system's architecture (32-bit or 64-bit).
Review the Denodo ODBC driver configuration: The configuration of your Denodo ODBC driver in the Windows ODBC Data Source Administrator might be incorrect. Go to Control Panel > Administrative Tools > ODBC Data Sources, and then review the setup for the Denodo ODBC driver. Pay attention to the data source name, server name, and port.
Validate the Connection String: Sometimes, the issue can be with the connection string you are using in Power BI to connect to Denodo. Verify that your connection string parameters are correct.
Test the ODBC Connection: You can test the connection from the ODBC Data Source Administrator. Go to the 'User DSN' or 'System DSN', select the Denodo data source and click 'Configure'. Once in the configuration window, there should be a 'Test' button. If the test fails, it will likely give you a more detailed error message that you can use to debug.
Update Gateway: If you are using Power BI gateway to refresh your data, ensure that the gateway is up-to-date. Outdated gateway versions can cause various connectivity issues.
Firewall and Network issues: Check to see if there's a firewall or other network device that could be blocking the connection. You might need to contact your network administrator for this.
Contact Denodo Support: If you're still unable to resolve the issue, I would suggest reaching out to Denodo Support. They could help diagnose the issue, especially since it involves their ODBC driver.
Remember that after making changes to your ODBC configuration or installing a new driver, it's a good idea to restart Power BI (and possibly your machine) to ensure the changes are picked up.