Forum Discussion
Object-level security for Analyze in Excel
Hi GilbertQ, this magically started working for me today. There seems to be some sort of conflict when I'm using the test account in Excel but logged into Windows with my main admin account. It seems to be confused about who's accessing the dataset somehow, but I haven't figured out exactly when it happens. So it doesn't look like it's an issue with the object-level security at all, but something account related. Thanks for taking the time to try helping with this!
Hi mmcanelly
Have you added the user to the Role in the Power BI Service?
Also the user cannot be a member of the app workspace or higher as that will allow them to see everything.
Hi GilbertQ,
Yep, I've set the roles up for the data source in the Power BI service. The user I'm testing doesn't have access to the workspace, but has been set with Read and Build access to the dataset.
Here are all the settings I have:
- Roles created in Power BI desktop
- Object-level security set up on the columns in the tabular model
- Account added to the Limited Access role in the security settings for the dataset in the Power BI service
- Account given Read and Build permissions in the dataset permissions
This all works as intended and limits the columns the user can see when using the dataset within Power BI Desktop or Service. The only place it isn't working is within Excel (Analyze in Excel from the service or loading a Power BI dataset from an Excel pivot), which is where I really need it.
Hi mmcanelly
It is working for me when I have set up Object Level Security. Can you confirm that you have set the column permissions on the table?
Hi GilbertQ, this magically started working for me today. There seems to be some sort of conflict when I'm using the test account in Excel but logged into Windows with my main admin account. It seems to be confused about who's accessing the dataset somehow, but I haven't figured out exactly when it happens. So it doesn't look like it's an issue with the object-level security at all, but something account related. Thanks for taking the time to try helping with this!
- Roles created in Power BI desktop