Connection modes in Power BI and how they work

Question

Accepted Answer

Power BI has three connection modes: Import, DirectQuery, and Live Connection.

Import mode imports data into Power BI and creates a dataset.
DirectQuery mode connects to the data source and queries data in real-time.
Live Connection mode connects to a published dataset in Power BI Service.
Import mode is best for small to medium-sized datasets, while DirectQuery and Live Connection are better for large datasets.
DirectQuery and Live Connection require a live connection to the data source.
DirectQuery and Live Connection allow for real-time data analysis and updates.
Import mode allows for data transformation and modeling before importing into Power BI.
Live Connection mode allows for multiple reports and dashboards to use the same dataset.
DirectQuery and Live Connection require proper permissions and security settings to access the data source.

Top Accenture Power BI Developer interview questions & answers