automatic refresh

[Anonymous]

Hello,

I connected the power BI desktop to MySQL database via import and not directquiery since directquiery does not work to me.

I uploaded the report to the power BI online and I downloaded the gateway in order to set up an automatic refresh of the data during the night. However since I am not connected during the night the automatic refresh does not happen. What should I do to set up an autimatic refresh during the night while the computer is off.

Thanks

[GilbertQ]

What I would like to add to, is that when the dataset needs to be refreshed via a Gateway the Gateway has to be up and running in order for the dataset refresh to take place.

If you can have your laptop/pc/server always on and connected this can solve your issue.

If you cannot, then as suggested a virtual machine or another computer that is always on and connected to the required network will work too.

[KBO]

Hi @Anonymous ,

If this solved your problem please shut down the case. This will help others as well :).

Best,

Kathrin 

If this post has helped you, please give it a thumbs up!
Did I answer your question? Mark my post as a solution!

[KBO · Accepted solution]

Hi @Anonymous ,

try to set up a virtual machine which is continiously online.

https://azure.microsoft.com/de-de/free/virtual-machines/search/?ef_id=Cj0KCQjw-O35BRDVARIsAJU5mQUHE6-qE9cSr7XDRHj-0W2q6EiqJEYfTY7z_p3-zPyuynORd4EMLwEaAtr6EALw_wcB%3AG%3As&OCID=AID2100049_SEM_Cj0KCQjw-O35BRDVARIsAJU5mQUHE6-qE9cSr7XDRHj-0W2q6EiqJEYfTY7z_p3-zPyuynORd4EMLwEaAtr6EALw_wcB%3AG%3As&dclid=CM74jdv-pOsCFVuKdwodr9UDbg

Best,

Kathrin

If this post has helped you, please give it a thumbs up!
Did I answer your question? Mark my post as a solution!