Showing results for 
Search instead for 
Did you mean: 
Helper I
Helper I

Power Bi Service - Refreshing Dataset while laptop is off



I've been trying to find a way to refresh a dataset while my machine is turned off. 


Currently I have a personal gateway installed in order to connect to my companies sharepoint and an internal API. I understand that a gateway needs to be installed on a machine/laptop that is on at all times. However this is not really feasible in my scenario.


One potential workaround (

that I've found is to try and install a gateway onto a virtual machine that will always remain active.


Does anyone have any alternative solutions?


Many thanks,



Frequent Visitor



You can create a dataflow in PowerBi Service and connect it to your Sharepoint, then connect this Dataflow in you PowerBi dataset (In Desktop). You'll be able to schedule a refresh in your Dataflow after that

For your internal API, you'll maybe have to connect it to a database before create un Dataflow

Thanks for your response. 


In regards to connecting my API to a database - do you mean connecting the API to a SQL server and then creating a dataflow to refresh the SQL server?



Helpful resources

Winner of T-Shirt Design

Power BI T-Shirt Design Challenge 2023

Find out who won the T-Shirt Design Challenge and the top 3 finalists.

March 2023 Update3

Power BI March 2023 Update

Find out more about the March 2023 update.

Top Solution Authors