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.
Choosing Get data > Power BI semantic model creates a live connection to SalesAnalytics. Power BI Desktop does not import the data; it simply queries the shared semantic model, so only one copy of the data and model definitions exists. The live connection automatically applies any row-level security that is already defined. Connecting directly to the SQL database would bypass the vetted semantic model, potentially break security rules, and duplicate modelling effort. Downloading the PBIX moves the model to a separate file, creating maintenance overhead and risking multiple versions. Analyze in Excel generates an Excel workbook, not a Power BI Desktop report, and importing that workbook would still create a separate model copy. Therefore, only the live connection meets all requirements.
Ask Bash
Bash is our AI bot, trained to help you pass your exam. AI Generated Content may display inaccurate information, always double-check anything important.
What is a semantic model in Power BI?
Open an interactive chat with Bash
What is row-level security (RLS) in Power BI and how does it work?
Open an interactive chat with Bash
What is a live connection in Power BI Desktop?
Open an interactive chat with Bash
Microsoft Power BI Data Analyst
Prepare the data
Your Score:
Report Issue
Bash, the Crucial Exams Chat Bot
AI Bot
Loading...
Loading...
Loading...
Pass with Confidence.
IT & Cybersecurity Package
You have hit the limits of our free tier, become a Premium Member today for unlimited access.
Military, Healthcare worker, Gov. employee or Teacher? See if you qualify for a Community Discount.
Monthly
$19.99
$19.99/mo
Billed monthly, Cancel any time.
3 Month Pass
$44.99
$14.99/mo
One time purchase of $44.99, Does not auto-renew.
MOST POPULAR
Annual Pass
$119.99
$9.99/mo
One time purchase of $119.99, Does not auto-renew.
BEST DEAL
Lifetime Pass
$189.99
One time purchase, Good for life.
What You Get
All IT & Cybersecurity Package plans include the following perks and exams .