Composite mode- User access - Issue

[krishnmoorthy]

Hi All, 

its urgent and we need suggestion

I am using Sharepoint site  - Import mode in Pwoer BI

Snowflake DB  - Direct query mode

More or less , it is composite mode

I applied RLS on Snowflake DB

When we shared dashboard in Power BI service, users are not able to see the dashboard. It means,the visuals are not rendering.

We have given workspace access, RLS , & link access. read & reshare in "Manage permission " . But still issue ?  can you pls help me ? 

[christinepayton]

Make sure the users have been added to the role in the service in security settings for the semantic model. You can "test as" a specific user in both desktop and cloud, that can help a lot to troubleshoot. 

[Shravan133 · Accepted solution]

When using a composite model in Power BI with both Import mode (from SharePoint) and DirectQuery mode (from Snowflake), and applying Row-Level Security (RLS) on the Snowflake data, there are several factors that could cause visuals not to render when shared in the Power BI service. Let's go through the possible reasons and solutions:

1. Verify RLS Configuration:

• Correct Roles Assigned:
  • Ensure that the users have been assigned the correct roles in the RLS settings within Power BI.
  • Verify that the roles are configured correctly to filter the data as intended.
• Snowflake Permissions:
  • Ensure that the users who are accessing the Snowflake data via DirectQuery have the necessary permissions in Snowflake itself.
  • The RLS in Power BI filters data based on the user’s access, but underlying permissions in Snowflake must allow the necessary queries to run.

2. Data Source Credentials:

• Snowflake Data Source Credentials:
  • Check if the credentials for the Snowflake data source are correctly configured in the Power BI service.
  • If users do not have the necessary permissions to access the Snowflake data source or if credentials are not correctly set, the visuals won’t render.
  • Go to the Power BI Service > Dataset Settings and confirm that the Snowflake data source credentials are set and correctly authenticated for the users.
• SharePoint Data Source Credentials:
  • Ensure that the credentials for the SharePoint data source are also correctly configured.
  • Users might need permission to access the SharePoint site content used in the Import mode.

3. Mixed Mode & RLS Limitations:

• RLS with Composite Models:
  • When using composite models, RLS might behave differently. Power BI applies RLS to the DirectQuery data, but it could impact the Import mode data if there’s a relationship between the tables.
  • Double-check that the relationships and RLS do not conflict, potentially filtering out all data unintentionally.

4. Check the User Permissions in Power BI Service:

• Workspace Access:
  • Ensure that users have at least Viewer access to the workspace where the dashboard resides.
  • Permission to Dataset: Users need read access to the dataset used in the report.
• Reshare Permissions:
  • If users need to share the dashboard further, ensure that they have the appropriate permissions under "Manage permissions."

5. Test with RLS Disabled:

• Testing Without RLS:
  • Temporarily disable RLS and see if the visuals render correctly. If they do, the issue is likely related to how RLS is filtering the data or a misconfiguration in RLS.