Microsoft Power BI Data Analyst Practice Question

Your organization has a certified semantic model named SalesAnalytics published in a Fabric workspace. You must build a new report in Power BI Desktop that reuses the model's existing measures and row-level security while keeping SalesAnalytics as the single source of truth (no data copy). What should you do first in Power BI Desktop?

  • Download the SalesAnalytics PBIX file, delete its report pages, and save a new file for reporting.

  • On the Home ribbon, select Get data > Power BI semantic model and connect to SalesAnalytics.

  • Use Analyze in Excel to connect to SalesAnalytics, then import the workbook into Power BI Desktop.

  • Start a DirectQuery connection to the underlying SQL Server database that feeds SalesAnalytics.

Microsoft Power BI Data Analyst
Prepare the data
Your Score:
Settings & Objectives
Random Mixed
Questions are selected randomly from all chosen topics, with a preference for those you haven’t seen before. You may see several questions from the same objective or domain in a row.
Rotate by Objective
Questions cycle through each objective or domain in turn, helping you avoid long streaks of questions from the same area. You may see some repeat questions, but the distribution will be more balanced across topics.

Check or uncheck an objective to set which questions you will receive.

Bash, the Crucial Exams Chat Bot
AI Bot