Power BI Data Connectivity and Data Sources Flashcards
7 cards from real Microsoft Power BI 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 Data Connectivity and Data Sources flashcards as text
What connection mode allows Power BI to query data directly from the source without importing it into the data model?
Answer: DirectQuery mode
DirectQuery mode sends queries directly to the data source each time a visual renders, without caching data in Power BI's in-memory engine.
Which of the following data sources supports Live Connection in Power BI Desktop?
Answer: SQL Server Analysis Services (SSAS)
Live Connection is supported for Analysis Services (SSAS) and Power BI datasets, allowing Power BI to connect without importing or duplicating the data model.
In Power BI Desktop's Import mode, what limits how many rows can be loaded from a data source?
Answer: Available system memory — there is no fixed row cap
Power BI Desktop imposes no hard row limit for Import mode; the practical ceiling is determined by available RAM on the machine.
Which connectors in Power BI can be used to retrieve data from REST APIs?
Answer: Both the OData Feed connector and the Web connector
Both the OData Feed connector (for OData-compliant APIs) and the Web connector (for general HTTP endpoints) can retrieve data from REST APIs in Power BI.
What is the primary purpose of the On-premises Data Gateway in Power BI?
Answer: To enable Power BI Service to securely access on-premises data sources
The On-premises Data Gateway acts as a secure bridge, enabling Power BI Service to reach data stored on local networks without exposing those sources directly to the internet.
Which of the following is NOT a valid storage mode in Power BI Desktop?
Answer: Hybrid Query
Power BI Desktop supports Import, DirectQuery, and Live Connection modes; 'Hybrid Query' is not a recognized storage or connection mode.
When connecting Power BI to an Excel file, which structural elements can be loaded as individual tables?
Answer: Excel Tables, named ranges, and entire worksheets
Power BI can load Excel Tables, named ranges, and entire worksheets as separate tables, giving flexibility in how Excel data is structured for analysis.