PL 400 Power BI Integration 4 — Questions and Answers
Question 1: A developer wants to use a Power BI dataset as the data source for a Power Apps canvas app without writing any code. Which connector enables this?
- SQL Server connector
- Power BI connector (Correct answer)
- Dataverse connector
- Azure Analysis Services connector
Correct answer: Power BI connector
The Power BI connector in Power Apps allows canvas apps to retrieve data from published Power BI datasets using DAX queries.
Question 2: A developer configures a Power BI workspace for integration with a Power Platform environment. Which workspace type supports XMLA endpoint access for advanced dataset operations?
- My Workspace
- Shared capacity workspace
- Premium or Fabric capacity workspace (Correct answer)
- Personal workspace
Correct answer: Premium or Fabric capacity workspace
XMLA endpoints are only available on workspaces backed by Premium capacity (P/A/EM SKUs) or Microsoft Fabric capacity.
Question 3: In a Power Automate cloud flow, a developer uses the 'Run a query against a dataset' Power BI action. What query language must be used?
- SQL
- KQL
- DAX (Correct answer)
- M (Power Query)
Correct answer: DAX
The 'Run a query against a dataset' action requires a DAX query to retrieve data from the Power BI dataset's tabular model.
Question 4: A developer needs to ensure that when a Power Apps form is submitted, the related Power BI dashboard refreshes automatically. What is the best approach?
- Schedule a daily Power BI refresh
- Trigger a Power Automate flow on form submission that calls the Power BI refresh API (Correct answer)
- Use DirectQuery mode in the dataset
- Enable incremental refresh in Power BI Desktop
Correct answer: Trigger a Power Automate flow on form submission that calls the Power BI refresh API
A Power Automate flow triggered on form submission can call the Power BI dataset refresh REST API endpoint to initiate an on-demand refresh.
Question 5: Which Power BI service feature allows developers to subscribe to dataset refresh notifications and trigger downstream processes?
- Power BI alerts (Correct answer)
- Power BI REST API refresh history polling
- Power BI dataflows waterfall refresh
- Power BI push notifications via SignalR
Correct answer: Power BI alerts
Power BI data alerts can send email notifications or trigger Power Automate flows when a dashboard tile's data crosses a defined threshold.
Question 6: A Power Platform developer needs to display a specific page of an embedded Power BI report. Which embed configuration property controls the initial page?
- defaultPage
- pageName (Correct answer)
- reportSection
- initialPage
Correct answer: pageName
The 'pageName' property in the Power BI JavaScript SDK's embed configuration specifies which report page to display on load.
Question 7: A developer is building a solution where Dataverse data changes must update a Power BI streaming dataset in near real-time. What combination achieves this?
- Dataverse change tracking + Azure Data Factory + Power BI import
- Dataverse plugin + Power Automate flow + Power BI push dataset (Correct answer)
- Dataverse virtual table + DirectQuery dataset
- Dataverse export to data lake + Power BI composite model
Correct answer: Dataverse plugin + Power Automate flow + Power BI push dataset
A Dataverse plug-in or Power Automate trigger can detect record changes and use the Power BI connector to push data to a streaming (push) dataset in near real-time.
PL 400 Power BI Integration 4
A developer wants to use a Power BI dataset as the data source for a Power Apps canvas app without writing any code.
Which connector enables this?