RLS with Direct Query

[jcs93]

I'm trying to get RLS working in a new report that has a mix of Direct Query and Import tables.  The DQ tables need to be DQ because they are coming from live data.

When I 'view as role', none of the tables from DQ get populated.  I've checked, double checked, read, read twice, and still can't seem to find an answer.

Thoughts please?

[TeigeGao]

Hi @jcs93 ,

Based on my test, the RLS works normally in Direct Query combined with Import, I uses the latest version of PowerBI. 

By the way, we can't see data in the Data tab when using Direct Query.

Best Regards,

Teige

[jcs93 · Accepted solution]

Thanks.  I ended up having to delete the queries, apply the changes, then re-add the queries for DQ.  They didn't like to be retrofitted.