Forum Discussion

jcs93's avatar
jcs93
Icon for Helper I rankHelper I
7 years ago
Solved

RLS with Direct Query

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?

Need Help
  • jcs93's avatar
    jcs93
    7 years ago

    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.

2 Replies

  • TeigeGao's avatar
    TeigeGao
    Icon for Solution Sage rankSolution Sage
    7 years ago

    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's avatar
      jcs93
      Icon for Helper I rankHelper I
      7 years ago

      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.