PL 400 Power BI Integration 3 — Questions and Answers
Question 1: Which Dataverse feature allows Power BI to query Dataverse data using TDS (Tabular Data Stream) endpoint without exporting data?
- Dataverse long-term retention
- Dataverse TDS endpoint (SQL access) (Correct answer)
- Dataverse virtual tables
- Dataverse change tracking
Correct answer: Dataverse TDS endpoint (SQL access)
The Dataverse TDS endpoint exposes Dataverse tables as a SQL-compatible data source that Power BI can connect to directly via the SQL Server connector.
Question 2: A Power BI report embedded in a model-driven app is not visible to a user. The workspace is set to Premium capacity. What is the most likely cause?
- The user lacks a Power BI Pro license
- The report URL is incorrect
- The user is not a member of the Power BI workspace (Correct answer)
- Power BI is not enabled in the environment
Correct answer: The user is not a member of the Power BI workspace
Even on Premium capacity, users must be members of the workspace (or the report must be in an app the user has access to) to view embedded reports.
Question 3: A developer uses Power Automate to export Power BI report data. Which action exports report data to a file format such as PDF or PPTX?
- Export to data lake
- Export report (Correct answer)
- Run a query against a dataset
- Refresh a dataset
Correct answer: Export report
The 'Export report' action in the Power BI Power Automate connector calls the Export API to render and download the report as PDF, PPTX, PNG, etc.
Question 4: Which Power BI feature should a developer use to allow Power Apps to read aggregated KPI data from a Power BI dataset without building a custom API?
- Power BI Goals (Scorecards)
- Power BI REST API datasets/executeQueries (Correct answer)
- Power BI Q&A visual
- Power BI paginated reports
Correct answer: Power BI REST API datasets/executeQueries
The executeQueries REST API endpoint allows external applications to run DAX queries against a published dataset and retrieve tabular results.
Question 5: When configuring row-level security (RLS) in Power BI for integration with Power Apps, which DAX function is used to filter data based on the logged-in user?
- USERNAME()
- USEROBJECTID()
- USERPRINCIPALNAME() (Correct answer)
- CURRENTUSER()
Correct answer: USERPRINCIPALNAME()
USERPRINCIPALNAME() returns the UPN of the authenticated user and is the standard function used in RLS role filter expressions.
Question 6: A developer needs to embed a Power BI report in a custom web application using the JavaScript SDK. What is the correct npm package to install?
- powerbi-client (Correct answer)
- powerbi-sdk-js
- msal-powerbi
- azure-powerbi-embed
Correct answer: powerbi-client
The 'powerbi-client' npm package is the official Microsoft Power BI JavaScript SDK for embedding reports in custom web applications.
Question 7: In Power BI embedding, what is an 'embed token' and how long is its default validity?
- An OAuth token valid for 7 days
- A short-lived token (1 hour by default) generated by the Power BI REST API for a specific report (Correct answer)
- A permanent API key issued per workspace
- A JWT token tied to the user's AAD session
Correct answer: A short-lived token (1 hour by default) generated by the Power BI REST API for a specific report
An embed token is generated via the GenerateToken API, is scoped to specific reports/dashboards, and expires in 1 hour by default (configurable).
PL 400 Power BI Integration 3
Which Dataverse feature allows Power BI to query Dataverse data using TDS (Tabular Data Stream) endpoint without exporting data?