Forum Discussion

adeelnazir786's avatar
6 years ago
Solved

Steps to implement Multi Tenant App for Non-Power BI Users

Please correct me if i;m wrong in any below step

 

I've power bi pro license, here is sample of my data model

1- Client( clientId, name, email, etc.)

2- Sales (Id, amount, clientId, prodId)

3- DimensionProd (Id, clientId, product detail...)

with one to many relation ship.

 

We have web wordpress web portal where our clients get loged in with different accounts (Non-Power BI Licensce)

let say [email protected], [email protected] there is no organizational account.

I want to filter the data w.r.t. loggen in account.

I know RLS is for it, i've applied RLS on Client table with DAX

[email] = UserPrincipleName(), through this way i can see view as role on desktop filtered data.

 

Now, i want to embed my dashboards on my wordpress web where clients get logged in and can see their filtered data.

I want to know, what will be the next process. Couldnt get any step by step guide from here to fulfill requirements.

Any helping video, documention will be appreciated.

 

Thanks & regards,

Adeel

  • Hi adeelnazir786 ,

     

    When you use secure embed code in your website, the embedded report still requires users to log in.

    After logging in, you could see the data using RLS.

     

2 Replies

  • v-eachen-msft's avatar
    v-eachen-msft
    Community Support

    Hi adeelnazir786 ,

     

    When you use secure embed code in your website, the embedded report still requires users to log in.

    After logging in, you could see the data using RLS.

     

    • adeelnazir786's avatar
      adeelnazir786
      Helper I

      😄

      Mistakenly clicked on accept as solution,

      any way, you mean to say by embed RLS every user have to get loggin using microsoft account ? on the other hand my clients dont have microsoft account (non power bi user) how he will see his dashboard's /data ?