You are developing a Power BI report to monitor critical, real-time manufacturing data using a DirectQuery dataset. The report will be published to a workspace on a Premium capacity. The business requires visuals to update as frequently as possible, but only when there is new data available, to minimize the query load on the source database. Which automatic page refresh configuration should you use to meet this specific requirement?
Configure automatic page refresh to 'Change detection'.
Enable the 'Personalized visuals' option in the report settings.
Configure a 'Scheduled refresh' for the dataset to run every minute.
Configure automatic page refresh to 'Fixed interval' and set the interval to 1 second.
The correct answer is 'Change detection'. This type of automatic page refresh is designed for this exact scenario. It uses a specific DAX measure to poll the DirectQuery source at a set interval. The full page of visuals will only refresh if the value of that measure has changed, indicating new data has arrived. This is more efficient than a 'Fixed interval' refresh, which would query all visuals on the page at every interval, regardless of whether the data has changed. 'Scheduled refresh' applies to the entire dataset (typically for Import mode) and does not provide real-time page updates. 'Enable personalized visuals' is an unrelated feature that allows end-users to change the visuals they see on a report.
Ask Bash
Bash is our AI bot, trained to help you pass your exam. AI Generated Content may display inaccurate information, always double-check anything important.
What is 'Change detection' in automatic page refresh?
Open an interactive chat with Bash
How does 'Fixed interval' differ from 'Change detection' in Power BI page refresh?
Open an interactive chat with Bash
Why is 'Change detection' better for minimizing query load in Power BI?
Open an interactive chat with Bash
Microsoft Power BI Data Analyst
Visualize and Analyze the Data
Your Score:
Report Issue
Bash, the Crucial Exams Chat Bot
AI Bot
Loading...
Loading...
Loading...
Pass with Confidence.
IT & Cybersecurity Package
You have hit the limits of our free tier, become a Premium Member today for unlimited access.
Military, Healthcare worker, Gov. employee or Teacher? See if you qualify for a Community Discount.
Monthly
$19.99
$19.99/mo
Billed monthly, Cancel any time.
3 Month Pass
$44.99
$14.99/mo
One time purchase of $44.99, Does not auto-renew.
MOST POPULAR
Annual Pass
$119.99
$9.99/mo
One time purchase of $119.99, Does not auto-renew.
BEST DEAL
Lifetime Pass
$189.99
One time purchase, Good for life.
What You Get
All IT & Cybersecurity Package plans include the following perks and exams .