Direct Query Report Not "refreshing"

[sgamage]

I created a report with a direct query connection to an On-Prem SQL Server.  When I refresh it on the desktop client the data will update but when I load it to the service it will say an update completed but will not display any new data.  I believe I setup the gateway correctly (using fully qualified domain and case sensitivty) and checking the gateway settings in the service everything says its able to connect and is online. I've also checked the gateway running on our server and dont see any issues there either.  If I take the same report and switch it to import mode it works fine.  Anyone have any ideas on things to check for?

[v-yuta-msft]

@sgamage ,

Please check if the on-premise data gateway has been updated to the lastest version.

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[sgamage]

@v-yuta-msft,

Yes I have Gateway Version 3000.2.52

[Anonymous]

Did you resolve this? I am also having teh same problem.