Forum Discussion
Memorable MemberScheduled refresh grayed out, after four consecutive (transient) failures
Super UserHi dbeavon3
I have found sometimes when this happens I have to wait a minute or two and I can then enable the schedule again.
An option that I use is Power Automate to do my refreshes for my datasets. This ensures that it always will run the refresh of dataset even if it has failed previously.
dbeavon3Hi GilbertQ
Thanks for the tip.
What finally worked for me is to expand the sections for "parameters", and then "gateway connections". Once those were expanded, the "scheduled refresh" settings became available again (no longer grayed out).
As in the past, I had to solve this problem in the PBI portal by randomly poking around in the dark.... It is really hard to understand how this stuff makes it past QA testing.
Given that you are using Power Automate to do refreshes for datasets, perhaps Microsoft decided that it is the best type of approach, and they may want everyone to follow your lead. Perhaps the normal scheduling settings are not commonly used these days. Or perhaps the people who use it are already aware of the quirks, and have a lot more patience with this U/I than I do.