Forum Discussion

Anonymous

Not applicable

1 year ago

Solved

How to allow AnalyzeInExcel to all users?

A user mentioned having the 'analyze in excel' grayed out: How can I allow this option to all users??

zenisekd
1 year ago
Workspace Permissions:

In Power BI, go to the workspace where your dataset is located.

Set permissions at the workspace level. Only allow "Analyze in Excel" access to users who are designated as members or contributors. Do not assign them the admin role unless necessary.

Assign Build Permissions:

In the dataset’s settings, navigate to the Manage Permissions page for the dataset you want to share.

Add only the users or groups that should have the ability to use "Analyze in Excel" and assign them the Build permission. This permission is necessary for them to connect and analyze the data externally while restricting other access.

Limit Permissions for Other Users:

Ensure that other users who should not have access to "Analyze in Excel" are either excluded from the workspace or are granted lower-level permissions, such as Viewer, without build access.

Restrict Download Permissions:

Disable the option for users to download reports or datasets within the workspace settings unless essential for specific roles.

This configuration allows finer control over who can connect to the Power BI dataset via Excel, keeping "Analyze in Excel" limited to only authorized users.

Anonymous

Not applicable

1 year ago

I don't see such thing as 'viewer permisson', I only see:

The dataset is a Live ssas DB.

I dont have admino on the tenant, but I do know the option is ON, because I can click "analyze in excel" myself and some other people... why is this?

Super User

1 year ago

Analyze in Excel could be allowed (in your case) only to certain security group / users.

Anonymous
Not applicable
1 year ago
Ok, its fine if its for certain users then. How can I allow it?
- zenisekd
  Super User
  1 year ago
  
  Workspace Permissions:
  
  In Power BI, go to the workspace where your dataset is located.
  
  Set permissions at the workspace level. Only allow "Analyze in Excel" access to users who are designated as members or contributors. Do not assign them the admin role unless necessary.
  
  Assign Build Permissions:
  
  In the dataset’s settings, navigate to the Manage Permissions page for the dataset you want to share.
  
  Add only the users or groups that should have the ability to use "Analyze in Excel" and assign them the Build permission. This permission is necessary for them to connect and analyze the data externally while restricting other access.
  
  Limit Permissions for Other Users:
  
  Ensure that other users who should not have access to "Analyze in Excel" are either excluded from the workspace or are granted lower-level permissions, such as Viewer, without build access.
  
  Restrict Download Permissions:
  
  Disable the option for users to download reports or datasets within the workspace settings unless essential for specific roles.
  
  This configuration allows finer control over who can connect to the Power BI dataset via Excel, keeping "Analyze in Excel" limited to only authorized users.