killobing.blogg.se

1. EXCEL GRAYED OUT OPTIONS INSTALL
2. EXCEL GRAYED OUT OPTIONS PRO

A user could have this permission in a few ways, such as having the Member role in the workspace containing the dataset, or having Build permission for a dataset in a workspace or in an app that contains the dataset. Users can connect to datasets through Analyze in Excel if they have permission for the underlying dataset.To learn more about the differences in functionality between license types, take a look at the Power BI features comparison section of Power BI pricing.

EXCEL GRAYED OUT OPTIONS PRO

Analyze in Excel requires that the dataset be in Power BI Premium or that the user have a Power BI Pro license.To correct the problem, just enter a formula like MyName, where. So if you have range names linked to the other workbook but you have no formulas in cells that are using those names, then Edit Links will be grayed out.

EXCEL GRAYED OUT OPTIONS INSTALL

If you’re unable to install the updates, check with your administrator. Here's one reason that Edit Links could be grayed out: Edit Links pays attention only to formulas in cells, not to range names.

Please make sure below options are enabled in admin portal: I do find a couple articles that get close:Ĭan anyone provide clarity or an article that outlines requirements/access levels for Analyze in Excel or any article explaining why this option is greyed out for workspace viewers?įirst, the "Analyze in Excel" feature require both options(Export data and Analyze in Excel) to be enabled. However, in our case for some documents this option is grayed out and for some of them its working as expected (Open In Excel option not grayed out). I cannot find an article outlining the restriction of Export > Analyze in Excel to be for Admins only. In this SharePoint shows small dialogue where it has Open In Excel option. As are Download Reports and several other download options there is not a specific option to allow Analyze in Excel (that I can find). I have verified that my tenant settings for Export to Excel are turned on for the entire organization. Troubleshooting seems to indicate the Analyze in Excel option is restricted to Admins of the workspace. Now the Analyze in Excel option is greyed out. I have users stating they used to be able to navigate in the web to Power BI reports and then select Export > Analyze in Excel. Hello - I hope this is posted in the best location.