nerdexam
Microsoft

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.

Explore and visualize data

Question

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. Which two actions should you perform? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

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)
  • A
    5% (2)
  • B
    85% (33)
  • C
    3% (1)
  • F
    8% (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.

AEnable Power BI embedded

Power BI embedded relates to embedding reports in applications and doesn't directly control the report's auto-refresh frequency.

BConfigure the data sources to use DirectQueryCorrect

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.

CConfigure the data sources to use a streaming dataset

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.

DSelect Auto page refreshCorrect

'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.

EEnable the XMlA endpoint

Enabling the XMLA endpoint allows for advanced dataset management but does not configure automatic report page refresh.

FAdd a Microsoft Power Automate visual to the report page.

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

#Auto page refresh#DirectQuery#Report design#Data refresh

Community Discussion

No community discussion yet for this question.

Full DP-500 Practice