Forum Discussion

Peppearson's avatar
Peppearson
Helper I
4 years ago

Power Bi Service - Refreshing Dataset while laptop is off

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,

 

 

Need Help

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    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's avatar
      Peppearson
      Helper I
      4 years ago

      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?