DP-500 · Question #11
You have a kiosk that displays a Power BI report page. The report uses a dataset that uses Import storage mode. You need to ensure that the report page updates all the visuals every 30 minutes…
The correct answer is B. Configure the data sources to use DirectQuery D. Select Auto page refresh. To achieve 30-minute automatic visual refresh on a Power BI report page with an imported dataset, you must configure the data source to use DirectQuery and enable Auto page refresh.
Question
Options
- AEnable Power BI embedded
- BConfigure the data sources to use DirectQuery
- CConfigure the data sources to use a streaming dataset
- DSelect Auto page refresh
- EEnable the XMlA endpoint
- FAdd a Microsoft Power Automate visual to the report page.
How the community answered
(39 responses)- A5% (2)
- B85% (33)
- C3% (1)
- F8% (3)
Why each option
To achieve 30-minute automatic visual refresh on a Power BI report page with an imported dataset, you must configure the data source to use DirectQuery and enable Auto page refresh.
Power BI embedded relates to embedding reports in applications and doesn't directly control the report's auto-refresh frequency.
For auto page refresh to work effectively and refresh visuals directly from the source at a frequent interval, the dataset's underlying data sources must be configured to use DirectQuery, allowing Power BI to query the source directly instead of relying on the imported data's last refresh.
A streaming dataset is designed for real-time data push, which is a different scenario from refreshing an existing report that uses an imported dataset.
'Auto page refresh' is a Power BI report setting that, when enabled, allows the report visuals to automatically update at a defined interval (e.g., every 30 minutes) by sending new queries to the data source.
Enabling the XMLA endpoint allows for advanced dataset management but does not configure automatic report page refresh.
A Power Automate visual is for triggering workflows, not for configuring automatic page refresh for all visuals based on a DirectQuery connection.
Concept tested: Power BI auto page refresh with DirectQuery
Source: https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-auto-page-refresh
Topics
Community Discussion
No community discussion yet for this question.