Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Any idea?
Nishant
Solved! Go to Solution.
Hi @Anonymous ,
Update, confirm that it needs to be saved as a copy before using "analyze 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.
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!
@KBOThanks for your response. Analyze in Excel is already enabled in our admin portal and we use it extensively.
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.
@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
Hi @Anonymous ,
Update, confirm that it needs to be saved as a copy before using "analyze 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.
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.
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!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.