Forum Discussion

vickyd's avatar
vickyd
Helper V
8 years ago
Solved

Run-time row level security like SSRS

Is it possible to have Power BI connect to multiple SSAS DBs and query data at run time honoring the row-level security setup in the models?

 

Basically, in SSRS today, we have several reports that connect to multiple Tabular Data Models each having row-level security. When user launches the report the queries run and fetch data as per the user's security. 

 

Looks like that's not possible at all in Power BI but want to confirm. If that is indeed true, is there a workaround?

  • Hi vickyd,


    Looks like that's not possible at all in Power BI but want to confirm. If that is indeed true, is there a workaround?


    Yes, that's true.

     

    Power BI cannot connect lively to multiple SSAS DBs currently. And I don't think there is an workaround. 

     

    In addition, here is a similar thread for your reference. :smileyhappy:

     

    Regards

1 Reply

  • v-ljerr-msft's avatar
    v-ljerr-msft
    Microsoft Employee

    Hi vickyd,


    Looks like that's not possible at all in Power BI but want to confirm. If that is indeed true, is there a workaround?


    Yes, that's true.

     

    Power BI cannot connect lively to multiple SSAS DBs currently. And I don't think there is an workaround. 

     

    In addition, here is a similar thread for your reference. :smileyhappy:

     

    Regards