Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
mariobatistella
Helper II
Helper II

Help with web service update automatic?

Good evening!
I have a firebird database imported into power bi desktop. I installed the gateway and set it to auto-update! Data is being updated correctly!
My problem is that I have a monitor on the wall plugged in all day, but the power bi web service doesn't update itself automatically!
Is there any possibility to resolve this?
Thanks!

17 REPLIES 17
Tutu_in_YYC
Resident Rockstar
Resident Rockstar

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!

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

Tutu_in_YYC_0-1655227423210.png

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. 😞

Good Morning!
I don't understand: why did you say auto refresh for 30mins interval? Is it some configuration?
Thanks!

In this scenario of mine, in 30min it updates automatically?

Correct, for your scenario, minimum every 30mins, the page/visuals will refresh.

Tutu_in_YYC_0-1655315026427.png

 

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!

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.

Good Morning!
The postgresql database must have external access to the internet, I mean its port with public access for directquery to work?
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!

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!

 

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Power BI Header Change

Power BI Header Update

Read about the exciting updates for the Power BI forum.

Top Solution Authors
Top Kudoed Authors