Emergency || Unable to create RLS for direct query dataset

[PremK]

I have created a new report using the DataSet's of 3 reports ( datasource - AWS Redshift ) which is already published in Servise. I just connected  these 3 datasets by direct query method directly through_ PBI Desktop - Get Data - PBI Semantic Model from Service. So for this combined new dataset the datasource would be PBI Service cloud.  due to this method i was unable to create new roles in PBI Desktop aswell unable to modify the existing roles, because Manage role option is not enabled.  If i publish the report the error showing as " you have to create rls in Desktop" but In Desktop there is no option for creating the RLS. Can anyone suggest me a solution to create RLS.

Please analyse the second image the Manage role option is not enabled...

But In Desktop the Creating Roles option is not enabled;

🤔

Spoiler

[Anonymous]

Hi, @PremK 

You'll need to go to each of the original datasets in the Power BI service that have permission to edit the dataset. In the dataset settings, you can manage or create new RLS roles. Go to the Power BI service and navigate to Dataset settings. Use security settings to manage RLS roles.
After you set up RLS in the source dataset, republish the report. Test by using different user roles to ensure that RLS is working as expected. You can use the View As feature in the Power BI service to simulate the reporting experience for different roles.

For a more in-depth understanding of how RLS works in Power BI, we recommend that you review the row-level security (RLS) guidance in Power BI Desktop article:

Row-level security (RLS) guidance in Power BI Desktop - Power BI | Microsoft Learn
To learn more about how to use datasets in the Power BI service in Desktop, see Connect to datasets in the Power BI service from Power BI Desktop:

Connect to semantic models in the Power BI service from Power BI Desktop - Power BI | Microsoft Lear...

How to Get Your Question Answered Quickly 

Best Regards

Yongkang Hua

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

[PremK]

This means, Existing Roles created for the already published reports ( from were i bring the 3 datasets of 3 rports in PBI Service to PBI Desktop as Direct query ) will also work for the new  report which i created and published ??
If this statement is true means, then why 
in the security setting of my new report in Service shows like this -

[Anonymous]

Hi, @PremK 

Sorry for being so late to get back to you.

PBI Desktop - Get Data - PBI Semantic Model from Service This way it seems that it is not possible to use Manage Role in Power BI Desktop. This seems to be a limitation, and only using Import and DirectQuery will be able to use Manage Role for reports. And you are using the semantic model on the service, I recommend that you download the semantic model you need on the service directly and then import it into Power BI Desktop and then use Manage Role. Or directly connect to your data source. At the same time, any previously defined RLS no longer works, and you need to recreate RLS

How to Get Your Question Answered Quickly 

Best Regards

Yongkang Hua

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

[PremK]

No.
1. In this way,  you cant import more than one downloaded semantic model into Desktop. for bringing the second and third semantic models the only option is you have to directly  connect it  from the Service as direct query ( because there is no option for Importing the other two downloaded semantic model datasets also in the same way...   if anyone know this pls let me know ). i had tryied this already, but here the issue is the RLS that your creating new through the imported semantic model dataset WILL NOT WORK for the other two Direct query datasets. 
Here we need to get solution for how to create RLS for Direct query Semantic model dataset  ?.

2. the second issue im facing in this data model is - I have created the new report with one Imported semantic model and two Direct queried semantic model dataset. But while bringing all three dsemantic models satasets together, the Table NAME of some of the same named Tables got changed by desktop defaultly. In Service unable to connect with the Data Source using Gateway -  the error sowing as One of the DataSource Is MISSING CREDENTIALS, and unable to solve this.

what o do now ?

[JB_AT]

Hi @PremK 

It seems to be only available for imported data, you will need to add the security at the source first https://learn.microsoft.com/en-us/power-bi/enterprise/service-admin-rls

Thanks

Joe

If you found my answer helpful and it solved your issue, please accept as solution