Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

power bi with web

Hi every One,

 

I want to ask if this feature available  in power  BI,

 

I have a web site 'portal', I want to show power by Report inside portal using Link Or button , the  report  must be shown based on the user ID That is Login, such as if  user id = 500  the report must show all data for  user 500, if  the get coming user id = 520 the  report must be shown ll data for  user 520.

7 Replies

  • TeigeGao's avatar
    TeigeGao
    Icon for Solution Sage rankSolution Sage

    Hi mohammed,

     

    Could you please share more information related to this problem? You want to embed the PowerBI Report to your web page or just provide a link to PowerBI Service? Which user ID will you use to filter the data? The PowerBI Service user or the user of your website?

    Generally, if it is PowerBI Service user, we can use dynamic Row Level Security, this method uses UserName() to recognize the current PowerBI Service user, then it will uses the security filter based on the username to other date, for more information, please refer to the following blogs:

    http://radacad.com/dynamic-row-level-security-with-power-bi-made-simple   

    https://community.powerbi.com/t5/Community-Blog/Power-BI-Dynamic-Row-Level-Security-Tips-to-get-it-working/ba-p/76865

    If it is just a link to the PowerBI Service Report, you can create a shared link for the report, then each user access to this report will see their own data.

     

    If it is an embedded page in your web page, please refer to this document: https://docs.microsoft.com/en-us/power-bi/developer/embedded-row-level-security

     

    If it is a web site user without power bi account, PowerBI doesn't provide a method to do this.


    Best Regards,

    Teige

    • Anonymous's avatar
      Anonymous
      Not applicable

      Hi TeigeGao ,

       

      Thanks for your reply.

      kindly  note that I will mention more information in the  below  :

       

      1. I want to Embedded Power BI Report inside the website.

      2. The website  build using Anguler 

      3. I Want to show report Based on the  user that is Login website "haven't Power BI Account"
      4. once the user login website "portal "using ID The report should be showing Based on Id value if the id = 500 show all data report for user 500 if user login id is  2401 show all data report for user 2401.

      • TeigeGao's avatar
        TeigeGao
        Icon for Solution Sage rankSolution Sage

        Hi mohammed,

         

        For the user who doesn't have PowerBI Service account, we cannot filter data for their userID because PowerBI Service cannot recognize these users.

         

        Best Regards,

        Teige

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi every One,

     

    I want to ask if this feature available  in power  BI,

     

    I have a web site 'portal', I want to show power by Report inside portal using Link Or button , the  report  must be shown based on the user ID That is Login, such as if  user id = 500  the report must show all data for  user 500, if  the get coming user id = 520 the  report must be shown ll data for  user 520.