Analyzing and Visualizing Data with Microsoft Excel — Question 69

You have a data model in Excel.
You export the data and the data model into a dataset in the Microsoft Power BI service.
What can you use to modify the data model that is published to the Power BI service?

Answer options

• A. Microsoft Power BI Desktop
• B. the Microsoft Power BI service only
• C. Excel and the Microsoft Power BI service
• D. Excel only

Correct answer: A

Explanation

The correct answer is A, Microsoft Power BI Desktop, as it allows for modifications to the data model before republishing it. Option B is incorrect because the Power BI service does not provide full data model editing capabilities. Option C is also incorrect since Excel can be used for data manipulation but does not directly modify the model in the service. Option D is wrong for the same reason; Excel alone does not modify the published model.