Forum Discussion

davekerby's avatar
davekerby
Icon for Helper II rankHelper II
9 years ago

Connecting to Power BI Service dataset

When i connect to a dataset in power bi service via power bi deskop i can see im connected but cant view and of the fields. Any ides why?          
Need Help
s_w's avatar
s_w
Frequent Visitor
8 years ago

Same problem here. For us, it seems related to an individual having limited access. There are a couple of fields that the person in question is not allowed to see. Maybe this crashes the process that is responsible for retrieving the field list?

s_w's avatar
s_w
Frequent Visitor
8 years ago

We've confirmed that this is due to a user belonging to a role that has custom cell data read permissions in SSAS. We have a measure that contains salary data and is only available for certain indivuals. The settings in SSAS are as follows

 

Cell Data Restriction Settings

 

Does anyone have any advice on how we can fix this issue? It seems to be a bug in PowerBI, given that it works perferctly fine in Excel.