Test as role does not work with Single Sign-On (SSO)

[nirun00s]

Dear All,

I got this message --> Not supported: Test as role does not work with Single Sign-On (SSO)
Please help to advise this issue.

Thanks in advance

@nirun00s 

[V-yubandi-msft · Accepted solution]

Hi @nirun00s ,

Thank you for joining us on the Microsoft Fabric Community Forum.

Core reason: Test as role does not work with Single Sign-On (SSO) occurs due to a limitation in Power BI.

• The test as role feature allows developers to simulate Row-Level Security (RLS) to see how specific roles affect data visibility. When SSO is enabled, Power BI uses the real user's identity for data source authentication.
• With SSO enabled, Power BI cannot simulate roles because it always uses the authenticated user’s identity.
• To get seamless SSO connectivity, configure your on-premises data gateway for real-time updates of Power BI reports and dashboards.

         Overview of single sign-on for on-premises data gateways - Power BI | Microsoft Learn.

• With Power BI, you can use Row-Level Security (RLS) to limit data access for certain users. This RLS feature is only effective for users who have Viewer permissions.

         Row-level security (RLS) with Power BI - Microsoft Fabric | Microsoft Learn.

To address your query, please follow the steps outlined below:

1. Identify the application displaying the error message regarding SSO and role testing.
2. Log in to the application and navigate to the section where your dataset is located.
3. Access the settings for your dataset by clicking on the ellipsis (three dots) next to it and selecting "Settings."
4. Look for any options related to Single Sign-On (SSO) in the dataset settings. If there is an option to temporarily disable SSO, consider doing so for testing purposes.
5. If you have the ability, create a test user account that has the role you want to test, ensuring that this user does not have SSO enabled.

Please refer to the official documents below for more details:

Overview of single sign-on for on-premises data gateways - Power BI | Microsoft Learn.

If my answer addressed your query, kindly mark it as the Accepted Solution to assist others.

I'd also be grateful for a 'Kudos' if you found my response useful! 

[V-yubandi-msft · Accepted solution]

Hi @nirun00s ,

Thank you for joining us on the Microsoft Fabric Community Forum.

Core reason: Test as role does not work with Single Sign-On (SSO) occurs due to a limitation in Power BI.

• The test as role feature allows developers to simulate Row-Level Security (RLS) to see how specific roles affect data visibility. When SSO is enabled, Power BI uses the real user's identity for data source authentication.
• With SSO enabled, Power BI cannot simulate roles because it always uses the authenticated user’s identity.
• To get seamless SSO connectivity, configure your on-premises data gateway for real-time updates of Power BI reports and dashboards.

         Overview of single sign-on for on-premises data gateways - Power BI | Microsoft Learn.

• With Power BI, you can use Row-Level Security (RLS) to limit data access for certain users. This RLS feature is only effective for users who have Viewer permissions.

         Row-level security (RLS) with Power BI - Microsoft Fabric | Microsoft Learn.

To address your query, please follow the steps outlined below:

1. Identify the application displaying the error message regarding SSO and role testing.
2. Log in to the application and navigate to the section where your dataset is located.
3. Access the settings for your dataset by clicking on the ellipsis (three dots) next to it and selecting "Settings."
4. Look for any options related to Single Sign-On (SSO) in the dataset settings. If there is an option to temporarily disable SSO, consider doing so for testing purposes.
5. If you have the ability, create a test user account that has the role you want to test, ensuring that this user does not have SSO enabled.

Please refer to the official documents below for more details:

Overview of single sign-on for on-premises data gateways - Power BI | Microsoft Learn.

If my answer addressed your query, kindly mark it as the Accepted Solution to assist others.

I'd also be grateful for a 'Kudos' if you found my response useful! 

[V-yubandi-msft]

Hi @nirun00s ,

Just a quick follow-up as we haven't heard from you yet. We hope the solution we provided was helpful. If you need any more assistance or have additional questions, please feel free to reach out.

We're always here to help, and your feedback is important to us. Looking forward to hearing from you soon.

Thank You.

[nirun00s]

Dear @V-yubandi-msft ,

Thank you for supporting me. I have checked all relevant to SSO in Settings but not found any related. Because my data source are from Azure DB  and Power BI Dataset please see the following figure...

If you have any suggestion, please let me know. Thank you.

[V-yubandi-msft · Accepted solution]

Hi @nirun00s ,

The issue might be related to the authentication method used with your cloud connections. Using Personal Cloud Connect for both sources could be causing conflicts with the role testing functionality.

Please consider switching from Personal Cloud Connect to another authentication option. Ensure that all required permissions are correctly set up for both data sources. 

Could you help us verify your access permissions to ensure everything is in place?

If you need further assistance, please let us know.

[V-yubandi-msft]

Hi @nirun00s ,

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution we provided for your issue worked for you  or let us know if you need any further assistance?

Your feedback is important to us, Looking forward to your response. 

Thank You.

[nirun00s]

Dear @V-yubandi-msft ,

I have checked as your suggestion. It works. Thank you.

Best regards,

Sarita

[V-yubandi-msft]

Hi @nirun00s ,

We wanted to follow up as we haven't received a response yet. We hope our solution was helpful. If you need further assistance or have any additional questions, please feel free to reach out.

We are always here to support you and appreciate your feedback. We look forward to hearing from you soon.

Thank you.