Microsoft Power BI Power BI Data Connectivity and Data Sources

Question 1

What connection mode allows Power BI to query data directly from the source without importing it into the data model?

Accepted Answer

DirectQuery mode

Answer

DirectQuery mode sends queries directly to the data source each time a visual renders, without caching data in Power BI's in-memory engine.

Question 2

Which of the following data sources supports Live Connection in Power BI Desktop?

Accepted Answer

SQL Server Analysis Services (SSAS)

Answer

Live Connection is supported for Analysis Services (SSAS) and Power BI datasets, allowing Power BI to connect without importing or duplicating the data model.

Question 3

In Power BI Desktop's Import mode, what limits how many rows can be loaded from a data source?

Accepted Answer

Available system memory — there is no fixed row cap

Answer

Power BI Desktop imposes no hard row limit for Import mode; the practical ceiling is determined by available RAM on the machine.

Question 4

Which connectors in Power BI can be used to retrieve data from REST APIs?

Accepted Answer

Both the OData Feed connector and the Web connector

Answer

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.

Question 5

What is the primary purpose of the On-premises Data Gateway in Power BI?

Accepted Answer

To enable Power BI Service to securely access on-premises data sources

Answer

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.

Microsoft Power BI Practice Test

Microsoft Power BI Practice Test

Microsoft Power BI Power BI Data Connectivity and Data Sources