Forum Discussion
Help with web service update automatic?
Thank you for your attention!
If I can't solve it, I'll lose my project!
So I changed the scenario to postgresql, which is another database I know a little about.
I left it set to storage mode as DirectQuery, but as my database is not public on the internet, I think that's why it gives the following error in the power bi web service: "the postgres data source has missing credentials and cannot be accessed. "
I also used the gateway, setting the storage mode to import, and I used ODBC from postgresql, as I saw some comments that it could work, but it doesn't, because it doesn't give me the option to auto-refresh!
Friend, please, just confirm my doubt: using firebird or postgresql, is there any possibility to configure auto-refresh on the page?
Because if not, I'll have to give up!
Thank you so much again!
According to Power BI you can use auto-page refresh if:
1- You data source supports directquery
2- For faster than 30min refresh interval you need premium capacity
Postgresql is supported, Firebird not.
Do you have premium capacity?
I have a pro license!
With postgresql's ODBC I managed to make it work, it's updating the data.
But my big problem is that it doesn't automatically update the web page.
Is there really no way?
Thanks!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?