Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

How to share programmaticaly a report

Hello,   I have an existing report that i want to share to external organisation users through my user portal. The users when they log in my portal must only see there own data in the report (mult...
General Comment
npergand's avatar
npergand
Helper II
4 years ago

Embedded is probably the best option for what you are looking for.

 

Here is the documentation on Embedded
https://docs.microsoft.com/en-us/power-bi/developer/embedded/

 

This doc explains what it is:
https://docs.microsoft.com/en-us/power-bi/developer/embedded/embedded-analytics-power-bi

 

Since you have an external user use case, you are probably looking to performing the "embed for you customers" method

 

Here is how you would implement it using a service principle:
https://docs.microsoft.com/en-us/power-bi/developer/embedded/embed-service-principal

 

Here is information on the licensing/pricing options:
https://docs.microsoft.com/en-us/power-bi/developer/embedded/embedded-capacity

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hello,

     

    First thank you for your time.

     

    If i understand well, service principale will be used to provide PI embedded user authentication through AD ?

    This mean users in my AD included in a RLS policy can only see their own data right ?

     

    Then it is mandatory to have those users in AD to share a report with RLS right ?

    This is also mandatory to have one PRO licence per user ?

     

    Regards.

    • npergand's avatar
      npergand
      Helper II
      4 years ago

      Using the "embed for you customers" method.

      You would use a Service Principle to authenticate to your AD and embed the report within your Application. I like the following graphic that illustrates the process (this came from a MS doc, but I can no longer find where I got it):

      This tutorial article walks you through step by step how to setup and configure this:

      https://docs.microsoft.com/en-us/power-bi/developer/embedded/embed-sample-for-customers

       

      You will need a Pro License (1 license per author) to author the reporting.

      If you use the Service Principle for embedding, you do not need a Pro License for it.

       

      External Users do not need to be in your AD, as the Application is responsible for authentication.

       

      RLS presents a challenge if the user is not in your AD, but you can accomplish proper RLS filtering by setting the CustomData property in your EffectiveIdentity to the external user and building your RLS query to be based off of that value (DAX: CUSTOMDATA())