Auditors need to analyze an existing semantic model from Excel by creating PivotTables connected to that model. They must not edit, publish, or delete any content in the workspace that hosts the model, and they should not be able to reshare items with others. Which action should you take to meet these requirements?
Assign the auditors to the workspace Viewer role only.
Assign the auditors to the workspace Viewer role and grant them Build permission on the semantic model.
Assign the auditors to the workspace Member role and enable Reshare permission on the semantic model.
Assign the auditors to the workspace Contributor role only.
Connecting to a Power BI semantic model from external tools such as Excel requires Build permission on the model. The workspace Viewer role gives read-only access but does not grant Build. Therefore, you assign the auditors to the Viewer role to prevent them from changing or resharing content, and then explicitly grant Build permission on the semantic model so they can create their own Excel reports. Contributor and Member roles would let them edit or publish items, which is not permitted, and Viewer without Build would block the Excel connection.
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 Build permission in Power BI?
Open an interactive chat with Bash
What is the Viewer role in a Power BI workspace?
Open an interactive chat with Bash
How do PivotTables connect to a Power BI semantic model?
Open an interactive chat with Bash
Microsoft Power BI Data Analyst
Manage and secure Power BI
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 .