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

[adeelnazir786]

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 abc@gmail.com, xyz@yahoo.com 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

[v-eachen-msft · Accepted solution]

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]

😄

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 ?