Forum Discussion
Help with web service update automatic?
Hello! you may need to set the automatic page refresh.
Check this link
https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-automatic-page-refresh
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!
