Usage Metrics - New Workspace

[Anonymous]

Hi there,

The new workspace usage metrics no longer shows the options for "Analyze in Excel". When I look at the documentation , it says that you can use "Analyze in Excel". But when I check my report the option is not there

https://docs.microsoft.com/en-us/power-bi/collaborate-share/service-modern-usage-metrics#customize-t...

Any idea?

Nishant

[KBO]

HI @Anonymous ,

I guess you must enable this function unter the Admin Portal. 

Best,

Kathrin

If this post has helped you, please give it a thumbs up!
Did I answer your question? Mark my post as a solution!

[Anonymous]

@KBOThanks for your response. Analyze in Excel is already enabled in our admin portal and we use it extensively. 

[V-lianl-msft]

Hi @Anonymous ,

I tested it and didn't reproduce your issue.

After creating the usage metrics report, I save it as a copy.

I can see "Analyze in excel" button in new workspace.

These two features are also enabled in my tenant.

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

@KBO Thanks for your response. It seems to be a bug. 

@V-lianl-msft  Thanks for your response. Your suggestion is a workaround and it does work but it requires me to save a new report and then get the option "Analyse in Excel" which doesn't seem right. Is there a reason this is not available in the actual report? 

Thanks

Nishant

[V-lianl-msft · Accepted solution]

Hi @Anonymous ,

Update, confirm that it needs to be saved as a copy before using "analyze in excel".

https://docs.microsoft.com/en-us/power-bi/collaborate-share/service-modern-usage-metrics#analyze-usage-data-in-excel 

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

@V-lianl-msft Thanks for clarifying. I have accept your reply as the solution. 

[V-lianl-msft]

Hi @Anonymous ,

Informed cx on the fix release . waiting for their response .

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[KBO]

Hi @Anonymous ,

checked it in my tenant and its the same you cant analyse in excel in the new workspace expirience.

Best,

Kathrin

If this post has helped you, please give it a thumbs up!
Did I answer your question? Mark my post as a solution!