Forum Discussion

adeelnazir786's avatar
adeelnazir786
Icon for Helper I rankHelper I
6 years ago

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

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 [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

Need Help
Show and Tell
Tips and Tricks

7 Replies

  • v-lionel-msft's avatar
    v-lionel-msft
    Icon for Community Support rankCommunity Support
    6 years ago

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

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

    • adeelnazir786's avatar
      adeelnazir786
      Icon for Helper I rankHelper I
      6 years ago

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

      • v-lionel-msft's avatar
        v-lionel-msft
        Icon for Community Support rankCommunity Support
        6 years ago

        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.