Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
PremK
Frequent Visitor

Unable to Create RLS | Emergency |

I have created a new report using the DataSet's of 3 reports which is already published in Servise. I just connected this these 3 datasets by direct query method directly from Service.  due to this method i was unable to create new roles in PBI Desktop aswell unable to modify the existing roles. 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.
In Service;

PremK_0-1711974060726.png


But In Desktop the Creating Roles option is not enabled;

PremK_1-1711974329465.png

 

1 ACCEPTED SOLUTION

The current connection to your dataset Amazon Redshift is Direct Query.

It is either you change to import so you will be able to configure RLS or open a ticket to the support team 🙂


Proud to be a Power BI Super User !

Microsoft Community : https://docs.microsoft.com/en-us/users/AmiraBedhiafi
Linkedin : https://www.linkedin.com/in/amira-bedhiafi/
StackOverflow : https://stackoverflow.com/users/9517769/amira-bedhiafi
C-Sharp Corner : https://www.c-sharpcorner.com/members/amira-bedhiafi
Power BI Community :https://community.powerbi.com/t5/user/viewprofilepage/user-id/332696

View solution in original post

6 REPLIES 6
MagicMind
New Member

I have the same issue. Is there any solution ?

AmiraBedh
Resident Rockstar
Resident Rockstar

What is your data source ?


Proud to be a Power BI Super User !

Microsoft Community : https://docs.microsoft.com/en-us/users/AmiraBedhiafi
Linkedin : https://www.linkedin.com/in/amira-bedhiafi/
StackOverflow : https://stackoverflow.com/users/9517769/amira-bedhiafi
C-Sharp Corner : https://www.c-sharpcorner.com/members/amira-bedhiafi
Power BI Community :https://community.powerbi.com/t5/user/viewprofilepage/user-id/332696

Mam, I just taken the 3 Dataset's of 3 reports allready published in Power BI Service, and i combined those 3 datasets into single one and created a new Report. So for this new report the DataSource should be PBI Service ( cloud ), right ?

Here the issue is i think, the 3 datasets i taken is through direct query mode from the already published reports, so the Manage Roles option is not enabled for me. ( Please refer the screenshots ive shared )
 What to do now ?

 

And the datasets available on PBI Service are coming from where ? 


Proud to be a Power BI Super User !

Microsoft Community : https://docs.microsoft.com/en-us/users/AmiraBedhiafi
Linkedin : https://www.linkedin.com/in/amira-bedhiafi/
StackOverflow : https://stackoverflow.com/users/9517769/amira-bedhiafi
C-Sharp Corner : https://www.c-sharpcorner.com/members/amira-bedhiafi
Power BI Community :https://community.powerbi.com/t5/user/viewprofilepage/user-id/332696

Mam, The DataSource for the 3 dataset's is Amazon Redshift.

 

Mam whether creating Dynamic RLS option would solve this issue ???

The current connection to your dataset Amazon Redshift is Direct Query.

It is either you change to import so you will be able to configure RLS or open a ticket to the support team 🙂


Proud to be a Power BI Super User !

Microsoft Community : https://docs.microsoft.com/en-us/users/AmiraBedhiafi
Linkedin : https://www.linkedin.com/in/amira-bedhiafi/
StackOverflow : https://stackoverflow.com/users/9517769/amira-bedhiafi
C-Sharp Corner : https://www.c-sharpcorner.com/members/amira-bedhiafi
Power BI Community :https://community.powerbi.com/t5/user/viewprofilepage/user-id/332696

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.