Forum Discussion
Odd Service update with on-premises data gateway
HI Anonymous,
>>For what you write, I'd need my computer to be never turned off or not connected to the Internet, which is pretty impossible. I think there's a way to take the updating frequency back to my setting when I turn my PC on.
Install gateway on a device which not often turn off is one of recommend option which written in official document.
If power bi service failed to check gateway online statutes, it obviously will put off refresh queue or cancel refresh operation.
>>I learned schedule refresh has a little bit of delay, but 3 hours of delay when switching my PC on are too much, aren't they? No updating while the PC is off is ok, but I need to find a way to have my reports refreshed at the frequency I chose when I switch it on, and not 3 hours later.
For this scenario, I'd like to suggest you turn off schedule refresh and click on 'refresh now' on power bi service to manually refresh. (it should quickly than schedule refresh)
Regards,
Xiaoxin Sheng
HI Anonymous,
I'd recommend you to take a look at following links about on premise data gateway and data refresh.
If that error is caused with turn on gateway, you can re-install your gateway to other device not often turned off.(prerequisite: possible to access to data source and connected to Internet)
Related Considerations:
- The gateway cannot be installed on a domain controller
- If you are planning to use Windows authentication, make sure you install the gateway on a computer that is a member of the same Active Directory environment as the data source(s).
- You shouldn't install a gateway on a computer, such a laptop, that may be turned off, asleep, or not connected to the Internet because the gateway can't run under any of those circumstances. In addition, gateway performance might suffer over a wireless network.
- Analysis Services is not required to use the gateway. You can use the gateway to connect to an Analysis Services data source.
For scheduled refresh, normally it has delay between 10 minute to hours or more, it can be related to your networks status and azure data service data amount.
You can consider to modify scheduled time to choose a free time to reduce cost of waiting and queue.
BTW, you can also contact to service support to know more about this.
Regards,
Xiaoxin Sheng
Hi Anonymous and thank for your answer.
Well I already read the 2 links you refer to, they helped me but I didn't find there anything useful (maybe I am not able to understand? I don't think so).
Sure my PC switches off during the night, so you are saying me it's normal because my gateway doesn't work when it get switched off. What do you mean saying I could re-install the gateway to another device? Where could I install it? I installed it really easily on my PC and I thought it was the only way, so what am I missing?
I learned schedule refresh has a little bit of delay, but 3 hours of delay when switching my PC on are too much, aren't they? No updating while the PC is off is ok, but I need to find a way to have my reports refreshed at the frequency I chose when I switch it on, and not 3 hours later.
For what you write, I'd need my computer to be never turned off or not connected to the Internet, which is pretty impossible. I think there's a way to take the updating frequency back to my setting when I turn my PC on.
Thank you very much
HI Anonymous,
>>For what you write, I'd need my computer to be never turned off or not connected to the Internet, which is pretty impossible. I think there's a way to take the updating frequency back to my setting when I turn my PC on.
Install gateway on a device which not often turn off is one of recommend option which written in official document.
If power bi service failed to check gateway online statutes, it obviously will put off refresh queue or cancel refresh operation.
>>I learned schedule refresh has a little bit of delay, but 3 hours of delay when switching my PC on are too much, aren't they? No updating while the PC is off is ok, but I need to find a way to have my reports refreshed at the frequency I chose when I switch it on, and not 3 hours later.
For this scenario, I'd like to suggest you turn off schedule refresh and click on 'refresh now' on power bi service to manually refresh. (it should quickly than schedule refresh)
Regards,
Xiaoxin Sheng