Automatic page refresh

[Anonymous]

Hello everyone, 

I am setting up an automatic refresh for my online Power BI report. I am using a personal gateway to do this. This method is currently working, but while the refresh is in process, my computer has to be on and it is rather unconvenient. I would like to know if there is another method that would allow me to leave my computer off while the refresh is in progress. FYI, my fact tables are imported from Dynamics and my dimension tables from Excel.

I hope someone has a solution for me.

Thanks in advance for your help,

Best regards,

François Miessen

[bilalrana · Accepted solution]

@Anonymous 
See this link: https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-automatic-page-refresh 

If this answers your question, please mark it as a solution!

[Anonymous]

Thank you for you reply @Rayizer , do you mean a virtual network data gateway?

[Rayizer]

@Anonymous not really. if your organization has VM set up, you can connect to it, install a gateway within, and keep it running.

Some helpful resources:
https://www.youtube.com/watch?v=Vlv1tbuZNcM

https://community.powerbi.com/t5/Service/How-to-make-Gateway-Online-all-the-time/m-p/2283868

[Rayizer]

@Anonymous we used a virtual machine to run 24/7