Live Connection in Power BI allows reports to connect directly to external data models, such as SQL Server Analysis Services (SSAS) or published Power BI datasets, without importing or storing data locally. This approach ensures real-time queries, centralised data management, and consistent business logic across reports. Understanding Live Connection is key to enterprise-level BI solutions.
Time limit: 0
Quiz Summary
0 of 15 Questions completed
Questions:
Information
You have already completed the quiz before. Hence you can not start it again.
What is the main characteristic of Live Connection in Power BI?
Correct
Incorrect
Question 2 of 15
2. Question
Which of the following supports Live Connection in Power BI?
Correct
Incorrect
Question 3 of 15
3. Question
Can you create new calculated columns in Live Connection mode?
Correct
Incorrect
Question 4 of 15
4. Question
Which feature is unavailable in Live Connection but available in Import mode?
Correct
Incorrect
Question 5 of 15
5. Question
In Live Connection, where is the data model stored?
Correct
Incorrect
Question 6 of 15
6. Question
Which refresh method is used in Live Connection mode?
Correct
Incorrect
Question 7 of 15
7. Question
Can Live Connection use Row-Level Security (RLS)?
Correct
Incorrect
Question 8 of 15
8. Question
Which icon appears in the status bar when a Power BI Desktop file uses Live Connection?
Correct
Incorrect
Question 9 of 15
9. Question
Which of these is a limitation of Live Connection?
Correct
Incorrect
Question 10 of 15
10. Question
Which storage mode is most similar to Live Connection?
Correct
Incorrect
Question 11 of 15
11. Question
Can you use Power Query transformations in Live Connection mode?
Correct
Incorrect
Question 12 of 15
12. Question
Which advantage does Live Connection have over Import mode?
Correct
Incorrect
Question 13 of 15
13. Question
When connecting live to a published Power BI dataset, authentication is handled via:
Correct
Incorrect
Question 14 of 15
14. Question
Which scenario is best suited for Live Connection?
Correct
Incorrect
Question 15 of 15
15. Question
What happens if the external model in a Live Connection goes offline?
Correct
Incorrect
Summary
These Live Connection in Power BI MCQs cover its definition, supported sources, limitations, storage location, RLS handling, and ideal use cases. Mastering Live Connection helps in building real-time, centrally managed enterprise reports with consistent business logic.
At QuizOrbit, our team specializes in fun, informative quizzes across topics like general knowledge, technology, and entertainment. Boost your knowledge with our expert-designed quizzes.
