topic Re: Automatic page refresh in Developer

Automatic page refresh

Anonymous — Wed, 17 Aug 2022 08:12:23 GMT

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

Re: Automatic page refresh

RayWu — Wed, 17 Aug 2022 08:42:35 GMT

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

Re: Automatic page refresh

Anonymous — Wed, 17 Aug 2022 09:11:23 GMT

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

Re: Automatic page refresh

RayWu — Wed, 17 Aug 2022 09:36:33 GMT

@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

Re: Automatic page refresh

bilalrana — Thu, 18 Aug 2022 09:33:34 GMT

@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!