cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
kp_pbi Frequent Visitor
Frequent Visitor

RLS Working in Desktop, but in when embedded

Hi

 

I'm trying to use RLS for an embedded report.

 

We pass a "username" via the API, and when the report opens we get "Visuals cannot display" error on all visuals.

 

In Desktop everything works no problem.

 

The problem report only has one table, and the report itself is only a matrix and 2 tables.

 

To test I used a different data set, with far less data, and that works fine with exactly the same setup.

 

Any ideas.... ? Can it be that RLS has a data size limitation ?

 

Any ideas welcome.

 

2 REPLIES 2
Moderator v-sihou-msft
Moderator

Re: RLS Working in Desktop, but in when embedded

@kp_pbi

 

What do you mean "pass a username via API"? 

 

Row Level Security supposes to take accessing Power BI account mapping into local domain user and apply row level filter defined in Role. There's no data size limitation for RLS. 

 

Regards,

Highlighted
kp_pbi Frequent Visitor
Frequent Visitor

Re: RLS Working in Desktop, but in when embedded

We use Power BI embedded, and when we open the Dashboard Report from our app, we pass a variable with the token, called "username". In Power BI, we then set a DAX Filter for [field_name] = username()

 

We have that setup for a few reports, some work, some don't - and there is no difference between them, so I'm trying to find the reason why some work and some don't. Any ideas ... ?

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

New Badges

Incoming: New and Improved Badges

Exciting news: We've given our badges an overhaul and added brand news ones.

Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Users Online
Currently online: 283 members 2,637 guests
Please welcome our newest community members: