Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Scheduled Refresh heading in dataset settings has disappeared for a report. After searching unsuccessfully, I found it under Optimize Performance. Is this a bug or intentional?
Solved! Go to Solution.
Hi, @FAY2020
When the workspace is premium per user / premium per capacity, and the data connection mode is DQ, "Optimize performance" will appear. And optimize preformance is equivalent to schedule refresh. It's not a bug.
Did I answer your question ? Please mark my reply as solution. Thank you very much.
If not, please feel free to ask me.
Best Regards,
Community Support Team _ Janey
Thank you for this post! For me the scheduled refresh only moved under "Optimize Performance" for my datasets with composite models (storage mode mixed with some imported tables, and one direct query connecting to a Power BI dataset). For all my other datasets with only imported tables, I still have the "Scheduled Refresh" section. This was driving me crazy, as I thought the scheduled refresh option was no longer available for datasets with composite models. Unfortunately I did not think of looking under the other sections, and have spent the past hour googling. I agree, terrible UX. Thanks again!
Hi, @FAY2020
Do you still have this interface now? What type of your data source is? I don’t see an exception here.
You can check this document: Configure automatic aggregations - Power BI | Microsoft Docs
Did I answer your question ? Please mark my reply as solution. Thank you very much.
If not, please feel free to ask me.
Best Regards,
Community Support Team _ Janey
I see - so this interface is specific to automatic aggregations.
It is still missig for me - see screenshot:
Hi, @FAY2020
When the workspace is premium per user / premium per capacity, and the data connection mode is DQ, "Optimize performance" will appear. And optimize preformance is equivalent to schedule refresh. It's not a bug.
Did I answer your question ? Please mark my reply as solution. Thank you very much.
If not, please feel free to ask me.
Best Regards,
Community Support Team _ Janey
So the refresh schedule configured under Optimize Performance will refresh my import sources? It's not just for automatic aggregations?
This seems an unnecessary change - I can't find this documented anywhere. Why not just leave scheduled refresh where it is? It may not be a bug but it sure as hell is bad UX.
In your initial screenshot, isn’t there a schedule refresh under Optimize Performance? It’s just that a new feature, automatic aggregations, has been added to premium capacity, so the name has changed, and schedule refresh is placed in Optimize Performance. Can't you use it ? ? ?
Reference:
Automatic aggregations overview - Power BI | Microsoft Docs
Configure automatic aggregations - Power BI | Microsoft Docs
Did I answer your question ? Please mark my reply as solution. Thank you very much.
If not, please feel free to ask me.
Best Regards,
Community Support Team _ Janey
You've missed my point and haven't answered my question:
"So the refresh schedule configured under Optimize Performance will refresh my import sources? It's not just for automatic aggregations?"
I'm not trying to be rude but the links you've provided are for Automatic Aggregations which is for Direct Query sources. I have import sources in my model, so the documentation isn't clear on refreshing them. I have mixed model datasets in non-premium workspaces which still have Scheduled Refresh available, so from a UX perspective this change is confusing.
I couldn't find anything while search but now this post is top of the Google results, so hopefully is anyone else has this issue they can see this. Thanks for your help.
If you doubt, you can check it after you modify the data and refresh. Refresh and automatic aggregates don't affect each other. They are different features, just under the same category.
Best Regards,
Community Support Team _ Janey
Thanks, I've verified that this does work. Still think it's awful UX though. Have a good day!
Interesting. It could be a temporary bug and probably due updates deployed by MSFT. Mine (US East) shows up correctly