Get or connect to data
9 practice questions under this official exam objective (PL-300) — each with the community-verified answer, a full option-by-option explanation and instant feedback.
Connecting Power BI Desktop to Azure DevOps Analytics views with the OData Feed connector
A bug tracking dashboard must consume Azure DevOps Analytics views from the cloud with server-side filtering, so Power BI Desktop must be pointed at t
Northwind Traders semantic model: choosing Import storage mode for the Power BI tables
A Power BI case study for Northwind Traders requires picking one storage mode for all tables in the semantic model, given that data must be current as
Push mode for real-time streaming without refreshing or stressing the data source
A frequently updated streaming data source must feed a report that shows real-time data with no dataset refresh and minimal performance impact on the
Three ways to repoint a PBIX file to a moved Excel data source
A PBIX file imports from an Excel file on a local network share that has been moved, and three distinct methods inside Power BI Desktop can update the
Two cloud connectors that refresh a OneDrive-hosted Excel file without a gateway
An Excel file living in OneDrive must load into a Power BI semantic model that refreshes in the Power BI service, requiring connectors that reach the
Only the VNet-hosted Azure SQL database needs an on-premises data gateway
A published semantic model combines an Excel file from OneDrive for Business, an Azure SQL database inside a virtual network, and a public website, an
Two-minute data freshness from Azure SQL requires DirectQuery connectivity
Model1 will read from Azure SQL database DB1 and must reflect data changes within two minutes, so the connectivity mode must show current source data
An on-premises data gateway keeps SSAS tabular data live in the Power BI service
A Desktop report reads from an SSAS tabular model on the company's internal network, and service consumers must see the most up-to-date data after the
PBIDS files simplify reconnecting another user to the same data source
Report1 in Power BI Desktop uses an Azure SQL database, and User1 needs the simplest path to connect to that same data source when building a report.