A dataset named "Sales Model" is already published in a Power BI workspace and is certified for enterprise use. You must build a new Power BI Desktop report that reuses all existing measures, hierarchies, and relationships in Sales Model and automatically reflects any future model changes without copying data. Which connection approach should you choose?
Download the Sales Model as a PBIX file and connect to that local file.
Create a connection to SQL Server Analysis Services in Import mode.
Import the tables through a Power BI dataflow and build a new model locally.
Use Get data and select Power BI semantic model, establishing a live connection to the published dataset.
Connecting to the dataset by selecting Get data > Power BI semantic model creates a live connection to the shared semantic model that resides in the Power BI service. The report immediately reuses all existing calculations and relationships, and any later changes to the published model are seen the next time the report is opened or refreshed. Importing data with a dataflow produces separate tables that do not share the certified model, using SQL Server Analysis Services requires access to an on-premises or Azure AS instance rather than a Power BI dataset, and exporting the dataset to a local PBIX breaks the single-source-of-truth requirement because changes made in the service will not flow back to the exported file.
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 live connection in Power BI?
Open an interactive chat with Bash
Why is a certified dataset important in Power BI?
Open an interactive chat with Bash
What is the advantage of using Power BI semantic models over importing data?
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 .