Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Key Influencer bug with RLS and/or Categorical fields

For some reason key influencer visuals with a categorical analysis type do not work well with RLS. When I view the visual as owner, the visual works fine. When I preview as a test user, the visual returns "Measures were not included in the analysis because a unique identifier could not be found". If I swap the analyze field with a measure the visual works fine in both cases. There is an index on the table.

Status: New
Comments
v-yuta-msft
Community Support

@MontyBurns ,

 

Please refer to the consideration below:

If the customer table doesn't have a unique identifier, you can't evaluate the measure and it's ignored by the analysis. To avoid this situation, make sure the table with your metric has a unique identifier. In this case, it's the customer table and the unique identifier is customer ID. It’s also easy to add an index column by using Power Query.

 

Reference:

https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-influencers#considerations-...

 

Regard,

Jimmy Tao

MontyBurns
Regular Visitor

Thanks Jimmy. The table has an index column.