Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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,
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
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?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.