Forum Discussion
Emergency || Unable to create RLS for direct query dataset
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;
🤔
5 Replies
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
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: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.
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 -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.
