ODBC data refresh

[Rejaul84]

Hi I get the below error when the scheduled refresh tries to run. manually refreshing the data on PBI Desktop is fine. Also this used to run fine until last week. Bit of a novice when it comes to backend of PBI.

Any help would be appriciated.

[aj1973 · Accepted solution]

Hi @Rejaul84 

If it is used to run and not now then you need to check for updates to both Power BI Gateway and the ODBC Drive.

[lbendlin · Accepted solution]

update the credentials for the nbshost dsn in the ODBC64 system dsn settings page on all gateway cluster VMs and in the gateway service.

[aj1973 · Accepted solution]

Hi @Rejaul84 

If it is used to run and not now then you need to check for updates to both Power BI Gateway and the ODBC Drive.

[Rejaul84]

Hi @aj1973 

It turned out that the account used for the gateway connection was disabled.

thanks for the help.