Forum Discussion
No Gateway
Hello,
You can install personal data gateway in your machine and you also need to connect your one drive to your pc as well, them just schedule a refresh on a time the machine will be on.
Regards!
ED
Thanks for the empathy! And a possible small solution for you regarding your statement " There is no option for "weekday" refreshes, just daily". This isn't true. I'm still in Trial and Error learning stage, so it took me a while to realize this. The Schedule Refresh settings in the Service work like SQL Server schedule settings. If you select Weekly, you can then check individual days of the week. For a given dataset, click Schedule Refresh. Turn it on. Immediately below the On button is the Refresh Frequency dropdown. Set it to Weekly. Checkboxes for each day of the week appear. Uncheck Saturday, Sunday. If you need 4 times per day, set up 4 schedules, one for 7am, one for noon, .... Set each one to run the Weekly schedule, Mon-Fri. But one will run at 7am, another at noon, etc.
WhiteBusLady again: I just realized PBI may not let you have multiple schedules per report. SQLServer does. But if you only need to update once per day my suggestion may still help.
I got lucky, my users like the reports so well they agreed to pay for a cloud server. We have other uses for it also, and this pushed them over the edge. But Microsoft licensing is expensive. No one answered one of my questions: Is there a Mac version of the gateway? More important, is there a LINUX version?