User of a security group are not able to access the Dashboard

Anonymous — Fri, 20 Sep 2024 09:37:14 GMT

User in a Security Group unable to access the content in the PowerBI Dashboard.

Re: User of a security group are not able to access the Dashboard

Anonymous — Mon, 23 Sep 2024 01:27:04 GMT

Hi, Anonymous

According to my research, the main reason for this problem is that you are using data from different tables and you are filtering the metric values with fields from different tables.
Below I will demonstrate to reproduce your question:

I have the following three tables:

Their relationship is as follows:

Use the fields of these three tables to build a visual, and then exclude one of them:

As a workaround for this error, you can use Power BI Desktop's filter to uncheck the fields you want to exclude in the filter for the current visual, which can also show the results after you want to exclude data. Alternatively, you can use advanced filtering to exclude fields that have an IS NOT:

You can refer to the following articles:

Understanding the "A measure is used in cross highlighting" error in Power BI (crossjoin.co.uk)

Fix Power BI Cross Highlight Not Working [6 Quick Ways] (10pcg.com)

Solved: Cant display this visual because a measure is used... - Microsoft Fabric Community

Best Regards

Jianpeng Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

topic User of a security group are not able to access the Dashboard in Report Server

User of a security group are not able to access the Dashboard

Re: User of a security group are not able to access the Dashboard