Forum Discussion
Using a local source with cluster gateway
Benoit_L I can't say I completely follow this, but I don't see why you would add an enterprise gateway to your local machine. Just offload that to servers that are always online.
For your second part, you need to move all files to accessible locations at all times if you are running refreshes. Get the local files into a shared location. Power BI is an all or nothing refresh, if all the files are accessible it will refresh, if something is missing, it breaks.
Benoit_L I can't say I completely follow this, but I don't see why you would add an enterprise gateway to your local machine. Just offload that to servers that are always online.
For your second part, you need to move all files to accessible locations at all times if you are running refreshes. Get the local files into a shared location. Power BI is an all or nothing refresh, if all the files are accessible it will refresh, if something is missing, it breaks.
Thank you Anonymous for your reply
About the first part, we are a small business so we do not have dedicated servers (at least at the moment, may change in the future). That's why I have configured multiple computers (including mine) into a cluster, to be sure to have always at least one online. I am taking any advice for doing this better.
Also I regularly update that local source on my computer, so I can not move it to a server (or I would have to upload it to the server each time I want to update PBI, which kind of breaks the process).
About the second part, ok thank you for the explanation. I now understand how it works.
Benoit_L A different option would be to spin up a small VM in Azure. Using Infrastructure as a Service (Iaas) you could provision a machine to handle the gateway. Shouldn't be to much setup work and Iaas acts like a server on premises so it should work without any issues.