Power BI Integration Flashcards
7 cards from real PL 400 practice questions. Tap to flip, then mark Knew It or Still Learning โ missed cards come back until you master them.
Read the first 7 Power BI Integration flashcards as text
Which Dataverse feature allows Power BI to query Dataverse data using TDS (Tabular Data Stream) endpoint without exporting data?
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.
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?
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.
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?
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.
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?
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.
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?
Answer: USERPRINCIPALNAME()
USERPRINCIPALNAME() returns the UPN of the authenticated user and is the standard function used in RLS role filter expressions.
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?
Answer: powerbi-client
The 'powerbi-client' npm package is the official Microsoft Power BI JavaScript SDK for embedding reports in custom web applications.
In Power BI embedding, what is an 'embed token' and how long is its default validity?
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).