Analyze in excel for Power BI Apps greyed out

[Anonymous]

Hi All,

In my Power BI Apps, i am not able to choose the option "Analyze In Excel" , it is greyed out , please advice.

Power BI

©Microsoft Corporation 2021. All rights reserved.

Service version13.0.16442.47
Client version2107.2.06866-train

Thanks

[erukulla_santh]

did you figure this out, what was the issue?

[JellyFishBi]

This has changed a bit since the advent of Fabric.

1) Select DataFactory from the lower left (Click on the PowerBi Icon)

2) Find your DataSet in the list
3) Apply build permission to your app

Cheers,

Mike

[Anonymous]

How can you use analyze excel feature?

I mean how can you convert the data into table format? 

[v-yetao1-msft]

Hi @Anonymous 

(1)Please check the settings in your admin portal , whether related functions have turned on .Then go to report to make sure whether the function has worked .

(2)Please check the report in workspace not in app ,whether you can analyze in excel .If no ,please check the limitations for Analyze in Excel . If yes ,publish the report to an app ,and then click Analyze in Excel in report .  

(3)Sign in your account in other computer or broswer to judge whether it is a browser problem .

I did a test. If your report can be analyzed in excel in the workspace, then after publishing to the app, you can still analyze in excel in the report .

Best Regards

Community Support Team _ Ailsa Tao

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

[selimovd]

Hey @Anonymous ,

can you get in contact with your Power BI Tenant admin?

He has to make sure the Analyze in Excel feature is enable in the tenant:

Also the export data feature has to be enabled:

If you need any help please let me know.

If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards

Denis

Blog: WhatTheFact.bi

Follow me: twitter.com/DenSelimovic

[Anonymous]

@selimovd thanks. If that was the issue i shouldn't be able to export the reports  either. I can export my reports as excel. Its the Power BI Apps that i cannot.

[selimovd]

@Anonymous Did you check the first option that "Use Analyze in Excel" is enabled?

[Anonymous]

@selimovd thanks. I am still waiting on the admin to get back, will update here for sure. Thanks for your time and patience. Greartly appreciate it.

[selimovd · Accepted solution]

@Anonymous if you know more, I would be happy if you could update us. Like this I know next time what was the reason 😊

[Anonymous]

@selimovd thanks. My Admin just emailed me and all those features you have mentioned are enabled.

Thanks