topic Error updating ODBC query in Report Server

Error updating ODBC query

ocastillo88 — Sun, 14 Apr 2024 00:01:16 GMT

Hi there,
I have a ODBC query running into my report, but my model cannot update automaticly as I have setup it.

The message is the following:

How can I resolve it?

Re: Error updating ODBC query

Greg_Deckler — Sun, 14 Apr 2024 00:23:38 GMT

ocastillo88 From the message it seems like your gateway is not reachable. Make sure it is turned on and make sure that the ODBC connection is configured on the gateway machine.

Re: Error updating ODBC query

ocastillo88 — Sun, 14 Apr 2024 00:55:58 GMT

Greg_Deckler for your answer.

I'll try it to verify the gateway connection.

Re: Error updating ODBC query

johnbasha33 — Mon, 15 Apr 2024 12:45:49 GMT

ocastillo88
Data Gateway: If your ODBC data source is hosted on-premises, you can install and configure a data gateway to enable scheduled refresh for your dataset in the Power BI service. The data gateway acts as a bridge between your on-premises data sources and the Power BI service, allowing for secure data transfer.

Did I answer your question? Mark my post as a solution! Appreciate your Kudos !!