Practice Test
True or False: Automatic page refresh is a feature only available in Power BI Desktop.
- True
- False
Answer: False
Explanation: Automatic page refresh is a feature available in Power BI service as well. It allows for near real-time update on reports.
Which of the following options does Power BI offer for configuring automatic page refresh?
- A) Page Refresh Schedule
- B) Direct Query
- C) Power Query
- D) Dataflow
Answer: A, B
Explanation: Power BI offers Page Refresh Schedule and Direct Query options for configuring automatic page refresh. Power Query and Dataflow are used for data transformation and data prep, not for automatic page refresh.
In Power BI, can automatic page refresh be configured at dataset level?
- Yes
- No
Answer: No
Explanation: Automatic page refresh in Power BI is configured at report level and not at the dataset level.
True or False: Automatic page refresh feature in Power BI can be used with Import mode datasets.
- True
- False
Answer: False
Explanation: Automatic page refresh feature in Power BI works with DirectQuery and Live Connect mode, not with Import mode datasets.
What is the shortest interval for automatic page refresh in Power BI?
- A) 30 seconds
- B) 1 minute
- C) 5 minutes
- D) 10 minutes
Answer: A) 30 seconds
Explanation: In Power BI, automatic page refresh can be configured to update the report as often as every 30 seconds.
True or False: The Automatic page refresh feature is available to Power BI Free users.
- True
- False
Answer: False
Explanation: Automatic page refresh is a Power BI Premium feature. It is not available to Power BI Free users.
Can Conditional auto page refresh be set based on a measure in Power BI?
- Yes
- No
Answer: Yes
Explanation: Conditional page refresh in Power BI allows you to set the page to refresh based on a measure. This allows for more dynamic and responsive reports.
Is it possible to set different refresh intervals for different pages in the same Power BI report?
- Yes
- No
Answer: Yes
Explanation: Automatic page refresh settings in Power BI are done at the page level, so you can set different refresh intervals for different pages in the same report.
True or False: The automatic page refresh option only works when the report is in reading view.
- True
- False
Answer: True
Explanation: The automatic page refresh only works when the report is in reading view or when it is published.
To configure automatic page refresh in Power BI, you first need to enable the feature under which settings?
- A) File Settings
- B) Page Settings
- C) Report Settings
- D) Power BI Settings
Answer: C) Report Settings
Explanation: In Power BI, you first need to enable the Automatic page refresh feature under the Report Settings before you can configure it.
True or False: You can configure automatic page refresh in Power BI using the REST API.
- True
- False
Answer: True
Explanation: You can set up automatic page refresh in Power BI programmatically using the Power BI REST API.
In Power BI, what is the automatic page refresh feature mostly used for?
- A) Performing complex calculations
- B) Querying large amounts of data
- C)achieving near real-time updates on reports
- D)Creating interactive dashboards
Answer: C)achieving near real-time updates on reports
Explanation: With Automatic page refresh on, the page checks for updates based on the defined time interval and updates the page, creating near real-time reports.
True or False: You need Power BI Pro license to use the Automatic page refresh feature.
- True
- False
Answer: True
Explanation: Automatic Page Refresh is a premium capacity feature, and it needs either Pro or Premium license to get used.
Which of the following is a limitation of automatic page refresh in Power BI?
- A) Cannot refresh more than once every 30 seconds
- B) Cannot refresh static data
- C)Does not work with DirectQuery
- D)Does not work in reading view
Answer: A) Cannot refresh more than once every 30 seconds
Explanation: One of the limitations of automatic page refresh in Power BI is that it cannot refresh more than once every 30 seconds.
Do you need to set the DirectQuery mode to utilize Automatic Page Refresh?
- Yes
- No
Answer: Yes
Explanation: The Automatic Page Refresh feature in Power BI works only with DirectQuery and Live Connect mode, therefore you need to set the DirectQuery mode to utilize it.
Interview Questions
What is automatic page refresh in Power BI?
Automatic page refresh in Power BI is a feature that updates the go-to display page automatically at regular intervals, fetching the latest data from data sources.
How is DirectQuery associated with automatic page refresh?
The automatic page refresh option is available only for DirectQuery data sources. DirectQuery does not load the data into Power BI memory but instead, sends queries directly to the data sources, therefore allowing fresh data on every refresh.
What types of data sources can use the automatic page refresh feature?
The automatic page refresh feature is only available for DirectQuery and Live Connection data sources.
What are the different types of automatic page refresh in Power BI?
There are two types of automatic page refresh settings in Power BI: Change Detection and Preset. Change Detection refreshes when changes are detected in the underlying data, while Preset allows you to set a predefined interval for refresh.
How can you configure an automatic page refresh in the Power BI service?
You can configure an automatic page refresh in the Power BI service by selecting the dataset settings in the settings pane, then setting the desired automatic page refresh frequency under Data Source Credentials.
What is the maximum frequency of automatic page refresh in Power BI?
The maximum frequency of automatic page refresh depends on the type of Power BI license. For Pro users, the minimum interval is 30 minutes, while for Premium users it can be as low as 1 minute.
Can free users use the automatic page refresh feature in Power BI?
No, the automatic page refresh feature is only available for Pro, Premium, and Premium per User (PPU) licenses.
What is the role of the “Refresh every” option when setting up automatic page refresh?
The “Refresh every” option enables users to define how frequently the page should be refreshed by setting the desired time interval.
Can you use the automatic page refresh on a report that uses an Import data model?
No, the automatic page refresh feature is not supported for reports that use an Import data model. The feature is only available for reports that are built on DirectQuery or Live Connection data sources.
What are the considerations when setting up change detection for automatic page refresh in Power BI?
When setting up change detection, you need to make sure the data source supports DirectQuery, the device running Power BI has permissions to connect to the data source, and the scheduled detection time does not conflict with office hours to avoid a slowdown of the underlying source system.
Where in the Power BI can automatic page refresh feature be activated?
The automatic page refresh feature is activated in the Dashboard settings of the Power BI.
How can you verify that automatic page refresh is working on your Power BI report?
You can verify that automatic page refresh is working by checking the time of the last data refresh displayed at the lower corner of your report.
Is there any limit on the number of pages that can be refreshed automatically in the Power BI?
No, there’s no specific limit on the number of pages. However, excess automatic refresh operations can lead to decreased performance or slower refresh times.
Can we pause the Automatic Page Refresh in Power BI?
Yes, users can manually pause and restart Automatic Page Refresh using the control provided in the status bar at the bottom of the Power BI interface.
Can we have different refresh durations set for different pages in a single Power BI report?
Yes, in Power BI, it’s possible to set different refresh durations for different pages within a single report.
extutorials.com