Forum Discussion
Data Mismatch
- Anonymous4 years ago
Logically it should not happen. But if it does, it could be because of any authorizations or RLS security feature. For example, if you have country level or product level authorizations set using RLS and if some customers or products are not mapped to respective geographical locations or product category groups, because of your elevated access, it is possible that you are able to see all the data including the unmapped customers or products (remember, DAX creates a blank row to map the unmapped items in relationships), but your colleagues are able to see only data that are mapped to the respective geographies or product groups because the RLS is filtering it.
Logically it should not happen. But if it does, it could be because of any authorizations or RLS security feature. For example, if you have country level or product level authorizations set using RLS and if some customers or products are not mapped to respective geographical locations or product category groups, because of your elevated access, it is possible that you are able to see all the data including the unmapped customers or products (remember, DAX creates a blank row to map the unmapped items in relationships), but your colleagues are able to see only data that are mapped to the respective geographies or product groups because the RLS is filtering it.