Forum Discussion
Help with web service update automatic?
If you dont have premium, it will only auto refresh for 30mins interval.
Unfortunately i am not aware of any other options. 😞
In this scenario of mine, in 30min it updates automatically?
Correct, for your scenario, minimum every 30mins, the page/visuals will refresh.
it has to be Direct Query. Page refresh only works with Direct Query. Try changing it back ti Direct Query, if not, create new query with Postgresql with Dircet Query.
So, but in my case, this "PAGE REFRESH" option doesn't appear, because I changed the storage mode to import here, and I'm using ODBC for postgresql, so the "PAGE REFRESH" option doesn't appear!
Is there no other way?
Thanks!I will try new connection with Postgresql and DirectQuery.
A question: must the port for the postgresql database be public, that is, with external access, I mean internet access, or does the gateway take care of that?
Thanks!Good Morning!
The postgresql database must have external access to the internet, I mean its port with public access for directquery to work?
Thanks!As long as you configure the connection credentials correctly, it should work ( based on Microsoft documentation). Try without a gateway first, if it doesnt work, configure the credential in a gateway.
Thanks a lot for the help!
I will study and test!good luck!