cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
VictoriaRosas Frequent Visitor
Frequent Visitor

Schedule Data Refresh

I have scheduled a refresh to occur daily, but it wont work when my computer is off. 

I'm a PowerBI pro user, and I have a personal Gateway. 
Me and my team need to update our reports on a daily basis without worrying on having any of our computers on. 

Any suggestions besides saving our files into OneDrive?

 

Me and my team would truly appreciate your help! 

 

Thanks!

 

 

2 ACCEPTED SOLUTIONS

Accepted Solutions
Super User
Super User

Re: Schedule Data Refresh

@VictoriaRosas 

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


Looking for more Power BI tips, tricks & tools? Check out PowerBI.tips the site I co-own with Mike Carlo. Also, if you are near SE WI? Join our PUG Milwaukee Brew City PUG

View solution in original post

Super User
Super User

Re: Schedule Data Refresh

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.


I have book! Learn Power BI from Packt


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

View solution in original post

8 REPLIES 8
Super User
Super User

Re: Schedule Data Refresh

@VictoriaRosas 

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


Looking for more Power BI tips, tricks & tools? Check out PowerBI.tips the site I co-own with Mike Carlo. Also, if you are near SE WI? Join our PUG Milwaukee Brew City PUG

View solution in original post

Super User
Super User

Re: Schedule Data Refresh

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.


I have book! Learn Power BI from Packt


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

Highlighted
Super User
Super User

Re: Schedule Data Refresh

@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.


Looking for more Power BI tips, tricks & tools? Check out PowerBI.tips the site I co-own with Mike Carlo. Also, if you are near SE WI? Join our PUG Milwaukee Brew City PUG
Super User
Super User

Re: Schedule Data Refresh

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.


I have book! Learn Power BI from Packt


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

View solution in original post

VictoriaRosas Frequent Visitor
Frequent Visitor

Re: Schedule Data Refresh

Thank you so much for your prompt response!

We were actually considering the second option, but we still have a lot of testing to do! 🙂

 

VictoriaRosas Frequent Visitor
Frequent Visitor

Re: Schedule Data Refresh

@Greg_Deckler @Seth_C_Bauer we are having issues with the schedule refresh. The data set refreshes 3 hours (on average, sometimes it only takes 30 min other 5 hours) after the time We have set.
Do you know if MS is working on this? We've been looking around for answers, but haven't found a solution! 

Thank you so much in advance!!!!! 🙂 

Super User
Super User

Re: Schedule Data Refresh

@VictoriaRosas That doesn't seem right at all. I would send a frown to support, they may be able to help you figure out what the issue is. 


Looking for more Power BI tips, tricks & tools? Check out PowerBI.tips the site I co-own with Mike Carlo. Also, if you are near SE WI? Join our PUG Milwaukee Brew City PUG
VictoriaRosas Frequent Visitor
Frequent Visitor

Re: Schedule Data Refresh

@Seth_C_Bauer thanks for the suggestion! I've done that, and they have submitted a ticket to work on that problem!
in the mean time we will schedule the refresh 3 hours prior our desire refresh time.

regards,

Helpful resources

Announcements
New Topics Started Badges Coming

New Topics Started Badges Coming

We're releasing new versions of the badge that everyone's talking about. ;) Check your inbox for notifications.

MBAS 2020

Save the new date (and location)!

Our business applications community is growing—so we needed a different venue, resulting in a new date and location. See you there!

Difinity Conference

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Solution Authors
Top Kudoed Authors (Last 30 Days)