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

[adeelnazir786]

Please guide right way

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 relationship. We have web wordpress web portal where our clients will be 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-lionel-msft]

Hi @adeelnazir786 ,

Did you manage your data model and add member for your role?

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[adeelnazir786]

Any idea to embed dashboard Into web same like secure embed report???

[v-lionel-msft]

Hi @adeelnazir786 ,

I'm sorry for the late reply.

In fact, PowerBI does not have the functionality of an embed dashboard. If you want to do this, you need to use a API. For more you can refer to the case:

How to Embed Power BI dashboard  

But you can embed the reports to websites, there're two ways:

1. Embed to website or portal. This method requires the report recipient to have a Pro license. And only users with Pro licenses or Premium-based reports can use this method.

2. Publish to web. 

In fact, if your report is set up with RLS, you will not be able to use the “Publish to web” sharing method.

For more, please refer to this:

Publish to web from Power BI 

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[adeelnazir786]

Sorry i mean Power bi report not dashboard.

But Really wierd for me,

You are saying power bi didnt support RLS with embedded system for Non-Power BI Users?

then what is App owns data? 

[v-lionel-msft]

Hi @adeelnazir786 ,

Sorry, my previous description is a bit wrong, and I have modified the previous answer.

"You are saying power bi didnt support RLS with embedded system for Non-Power BI Users?"

There are three "Embed" sharing methods in Power BI.

"SharePoint Online" and "Website or portal"  all require users to have a Power BI Pro license or Premium.

Embed with report web part in SharePoint Online 

Embed a report in a secure portal or website 

In other words, if you use these two methods, Non-Power BI Users will not be able to view the report, but RLS can work.

"Publish to web" allows anyone to view the report, including Non-Power BI Users, but if your reports have RLS, you can't use "Publish to web (I have tested)".

In fact, RLS is effective under other sharing methods, but the report recipients are required to have a Pro license or Premium.

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[adeelnazir786]

You means to say i can't use filter RLS in embedded report for non power bi users right?

if yes then what is Apps Own Data with RLS

Embedd report for Non-Power BI Users
https://docs.microsoft.com/en-us/power-bi/developer/embed-sample-for-customers

RLS for Embedded

https://docs.microsoft.com/en-us/power-bi/developer/embedded-row-level-security#using-rls-vs-javascr...

i just get confused... will above two resolve my issue?

[adeelnazir786]

 ok, then next steps to show dashboard on php web site with RLS embeded. Any helping material please