Power BI scheduled refresh issues for the My workspace/Group reports

[stangellapally]

Hello,

I've been experiencing this scheduled refresh issue for the reports uploaded in My workspace and Group reports. I am not sure if any one has been facing this issues or its just me doing something wrong. I have some reports created in My workspace and group space... where they get refreshed absolutely fine when my office 365 is signed in for Power BI web app. But the reports fail to refresh during weekends when I am offline (off course my system is shut down and I am not logged in Power BI web app). Here are some things I noticed:

a. After the weekend, on Monday when I login in to browser with my credentials and keep it ready for the scheduled refresh  they reports doesnt give an failed notice nor they get refreshed.

b. Since it doesnt give me any failed notice.... I always assumed it to refresh it to the latest values. But on the Power BI page, the dataset has that "yellow triangle with exclamation mark" for refresh failed on every monday after the scheduled refresh.

c. So everytime I had to again go in manually and refresh the data again.

So should we be always signed in for the reports to get refreshed? or is their any solution for reports to get refreshed even when we are offline?

[wonga]

What kind of gateway are you using to do your refreshes?

1. If it's a personal gateway, you must install it as an administrator in order for refreshes to occur even after you log off your computer. Your computer must stay ON in order for the personal gateway to work.
2. If it's an enterprise gateway, then it should work as long as the machine the gateway is installed on, remains on. (Preferably installed on a server).

[stangellapally]

Great! Thanks for the quick solution Wong. 🙂

But unfortunately the enterprise gateway option is grayed out for me to select. I will check with the admin if they need to new credentials to be created or use my existing ones.

[dimazaid]

Hi,
As Wong mentioned, you need to be an admin on the personal gateway to keep it running even when you're logged out. For the enterprise gateway, you need to add the data source from the Manage Gateways UI, if it's greyed out: check the credentials or it might be offline for some reason. 
Let us know if this issue persists, and if it resolved please marked the topic as resolved.
Thanks!
Dimah

[stangellapally]

Hi Dimazaid,

I've been trying to work with the admin in my office and no luck so far. Is there a place we can refere the steps to set up the enterprise gateway settings?

Thanks,

Swathi

[wonga · Accepted solution]

Hey @stangellapally, glad I could help in some way. If the option for an enterprise gateway is greyed out, it either means you don't have an enterprise gateway installed, or there is no appropriate data source that has been added to the gateway for your specific dataset.