Exam PL-900 All Questions

View all questions & answers for the PL-900 exam

Exam PL-900 topic 1 question 67 discussion

Actual exam question from Microsoft's PL-900

Question #: 67
Topic #: 1

You are a district manager for a large retail organization. You train each store manager to use Power BI to track sales and daily sales targets.
A store manager remembers learning about the Analyze in Excel option but cannot find the option in their Power BI dashboard.
You need to help the user resolve the issue.
How should you advise the user?

A. Install the Power BI Desktop app.
B. Select the Spotlight button on the dashboard tile.
C. Subscribe to the dashboard and follow the email link.
D. Navigate to the report used by the dashboard.

Show Suggested Answer

Suggested Answer: D 🗳️
Reference:
https://docs.microsoft.com/en-us/power-bi/collaborate-share/service-analyze-in-excel

by madhupowerup at Dec. 5, 2020, 10:12 p.m.

Comments

Submit Cancel

Oda

Highly Voted 3 years, 11 months ago

Answer is Correct "Analyze in Excel is a feature on Power BI datasets and reports published to the service. You can find it right in front of every report’s name as an action;"

upvoted 28 times

...

WaheedHaq

Most Recent 7 months, 1 week ago

Selected Answer: D

the correct advice is D. Navigate to the report used by the dashboard. Once you’re in the report, you’ll find the Analyze in Excel option to work with the data in Excel.

upvoted 1 times

...

intentando

1 year, 8 months ago

Selected Answer: D

Agree https://www.phdata.io/blog/page-navigation-in-power-bi/

upvoted 1 times

...

kumarGola

2 years, 1 month ago

Answer D is absolutely correct.

upvoted 1 times

...

Geynen

2 years, 8 months ago

Confirmed, it comes in the exam of 03/13/2022. my answer is D

upvoted 2 times

...

PraveenGabriel

3 years ago

Verified - this appeared on 11/13/2021

upvoted 4 times

...

Aunehwet79

3 years, 1 month ago

In exam 30th Oct 2021

upvoted 2 times

...

techwen

3 years, 5 months ago

The given answer D is correct

upvoted 4 times

...

JulieBee

3 years, 6 months ago

D is the correct answer. In the report view, click Export > Analyze in Excel.

upvoted 3 times

...

When_you_know_you_know

3 years, 8 months ago

The given answer is correct - Alternatively, you can navigate in the Power BI service to a dataset you want to analyze, and select the More options item for a dataset, report, or other Power BI item. From the menu that appears, select the Analyze in Excel option, as shown in the following image. https://docs.microsoft.com/en-us/power-bi/collaborate-share/service-analyze-in-excel#:~:text=%20In%20the%20Power%20BI%20service%2C%20navigate%20to,Enable%20Editing%20and%20then%20Enable%20Content%2C...%20More%20

upvoted 2 times

...

madhupowerup

4 years ago

Can anyone confirm if the answer mentioned is correct or not

upvoted 3 times

BenJames

3 years, 11 months ago

The given answer is correct. 1. A. Install the Power BI Desktop app. WRONG "Analyze in Excel is a Power BI service feature, and is not available in Power BI Report Server or Power BI Embedded". Although it does not state is not a desktop feature, it says it is a service feature so can cancel option 1 out. B. Select the Spotlight button on the dashboard tile. WRONG, spotlight is around highlighting a visual on a dashboard hence the name "Spotlight" . C. Subscribe to the dashboard and follow the email link. Wrong this will keep you up to date with the latest dashboard info but not going to help you analyze in excel is it! D. Navigate to the report used by the dashboard. CORRECT so this leaves us with the only logical answer left, "navigate in the Power BI service to a dataset you want to analyze, and select the More options item for a dataset, report, or other Power BI item" from here you then click analyze excel so CORRECT answer.

upvoted 34 times

vtm1

2 years, 10 months ago

hehe, explanations as they should appear every time, tnx!

upvoted 1 times

...

Guido

3 years, 9 months ago

Was just wondering, why aren't you investigating it yourself if the answer is correct or not, then you are learning something instead of relying on others.

upvoted 8 times

AmbitiousLearner

2 years, 11 months ago

Great contribution. But many people will still be insecure because a lot of questions are ambiguous. Hence, they need to clarify if they did actually understand it correctly

upvoted 5 times

...