Forum Discussion
Schedule Data Refresh
Couple Options other than OneDrive:
1) Schedule the refresh for a time when you know your computer should be running. (not ideal, prone to some errors)
2) You can install the gateway on any machine that stays running, as long as it has access to the file you are using to refresh the dataset.
For full details, read through the gateway details here
No, it's still in Preview, and you are correct, that is an important thing to point out. And there are preview-type limitations, such as available data sources, which should also be pointed out. But, it sounded like what VictoriaRosas was looking for was more along the lines of a single gateway that could handle multiple, different people's data sources and to my knowledge, Enterprise Gateway is the vehicle for that versus Personal Gateway, which is; well, for *personal* use. :)
Azure IaaS applies either way. For me personally, I have an Azure IaaS VM that I do some of this stuff with and I also have an old laptop that just sits and runs Personal Gateway all day as well.
So, you will want to investigate the Enterprise Gateway is my guess. A number of different options, but basically, you need to install the gateway on some computer that runs the service. A good option for this is often something like a VM running in Azure IaaS. If you get fancy, you can even schedule all of your refreshes for, let's say, a 4 hour window and then use powershell scripts to automatically spin up and shut down the VM for say, a 6 hour window. Then, you are only running and paying for the VM for those 6 hours of the day, which makes it incredibly cost effective.
Greg_Deckler Side note/question. I thought the Enterprise Gateway still only supports SQL Server, SSAS and SAP currently? So the datasource would need to be one of those I believe, and I think it's still in preview (which should be noted). Correct me if I'm wrong, I'm more asking then telling here.
No, it's still in Preview, and you are correct, that is an important thing to point out. And there are preview-type limitations, such as available data sources, which should also be pointed out. But, it sounded like what VictoriaRosas was looking for was more along the lines of a single gateway that could handle multiple, different people's data sources and to my knowledge, Enterprise Gateway is the vehicle for that versus Personal Gateway, which is; well, for *personal* use. :)
Azure IaaS applies either way. For me personally, I have an Azure IaaS VM that I do some of this stuff with and I also have an old laptop that just sits and runs Personal Gateway all day as well.