Don't miss your chance to take the Fabric Data Engineer (DP-600) exam for FREE! Find out how by attending the DP-600 session on April 23rd (pacific time), live or on-demand.
Learn moreJoin the FabCon + SQLCon recap series. Up next: Power BI, Real-Time Intelligence, IQ and AI, and Data Factory take center stage. All sessions are available on-demand after the live show. Register now
Hi, I'm testing out if direct query will meet my needs for a real-time dashboard. I've started getting this error every hour now on a scheduled refresh:
"Exceeded the refresh request limit for this dataset within the last 24 hours."
I've checked that I do not have a scheduled refresh set up and the automatic page refresh is turned off in the dashboard.
Does direct query always automatically set up an hourly scheduled refresh? How does this work with 8 times a day refresh limits? Am I always going to see this error after 8 hours a day?
Hi @jbaz ,
Please tell me whether you have solved this problem?
Best Regards,
Xianda Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @jbaz ,
Since Direct Query mode automatically opens to schedule tile refreshes, the default is one hour. If you're on a Pro license, you'll have 8 refreshes per day.
You can set the refresh time manually .Extend the single refresh time so that the number of refreshes per day decreases.
Below is the Microsoft’s official link:
Data refresh in Power BI - Power BI | Microsoft Learn
Best Regards,
Xianda Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Check out the April 2026 Power BI update to learn about new features.
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
| User | Count |
|---|---|
| 11 | |
| 10 | |
| 9 | |
| 8 | |
| 8 |