Power Bi Service - Refreshing Dataset while laptop is off

[Peppearson]

Hi,

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 (

https://community.powerbi.com/t5/Service/how-to-refresh-data-even-your-PC-offline/m-p/410646)

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,

[Anonymous]

Hello,

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

[Peppearson]

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?