Forum Discussion
Help with web service update automatic?
Good Morning!
I read all the link you indicated and I understand!
Even so, my question is: is there any way to make the page auto-update being my storage mode import using odbc gateway for firebird?
Is there any alternative that works?
Thanks for listening!
hi mario,
auto-update only works with direct query unfortunately. I am not familiar with firebird, but can you try using direct query with your database?
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 directquery2- 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!