Forum Discussion

Rejaul84's avatar
Rejaul84
Frequent Visitor
2 years ago
Solved

ODBC data refresh

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.

Need Help
  • aj1973's avatar
    aj1973
    2 years ago

    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's avatar
    lbendlin
    2 years ago

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

3 Replies

  • aj1973's avatar
    aj1973
    Community Champion
    2 years ago

    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's avatar
      Rejaul84
      Frequent Visitor
      2 years ago

      Hi aj1973 

       

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

       

      thanks for the help.

  • lbendlin's avatar
    lbendlin
    Super User
    2 years ago

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