PUG Exchange

Expand all | Collapse all

Show slicer selection based on user for non Power BI users(Embedded power BI)

  • 1.  Show slicer selection based on user for non Power BI users(Embedded power BI)

    Posted 9 days ago
    Hi,

    We are using embedded power BI on our application with one pro account to publish the reports/dashboards.
    I have a slicer with list of companies. When user 1 logs on to our application and launches the dashboard/report, I want to display just the companies for which he has access set on our application, other users should also see only the companies for which they have access.
    Our users do not have a pro license, they are external to our organization, and we are not on premium capacity. Is it still possible to enable access based on our requirement? I'd like to avoid creating multiple reports per user.

    Thanks

    ------------------------------
    Shilpa Vishwanath
    Architect, Business Intelligence
    Intelligent Hospitality
    ------------------------------


  • 2.  RE: Show slicer selection based on user for non Power BI users(Embedded power BI)

    Posted 8 days ago
    Row level security is available when using Power BI Embedded. This would be the best way to limit each user's view of the data dynamically and in a secure way.
    Use row-level security with Power BI embedded content - Power BI
    Microsoft remove preview
    Use row-level security with Power BI embedded content - Power BI
    Learn about the steps you need to take to embed Power BI content within your application.
    View this on Microsoft >




    ------------------------------
    David Pugh
    Principal Solution Architect
    CDW
    ------------------------------



  • 3.  RE: Show slicer selection based on user for non Power BI users(Embedded power BI)

    Silver Contributor
    Posted 7 days ago
    Shilpa, you may not have a (P)remium account but you will still need a dedicated capacity such that non Power BI users (free) can access your Power BI Embedded app. So you will need either an (A)zure license or an O365 (EM)bedded license to get the dedicated capacity ....that way you can create a 'dedicated' workspace to host your app reports/tiles/dashboards for which you will need an embedtoken for PBIEmbedded to function as you require.

    ------------------------------
    David Moss
    Advanced Analytics & Power BI Azure Solutions
    Wottabyte
    London
    ------------------------------



  • 4.  RE: Show slicer selection based on user for non Power BI users(Embedded power BI)

    Posted 7 days ago
    Thanks @David Moss When you say Azure License, we already use Azure pay-as-you-go subscription for our SQL licenses, we plan to avail the A1 capacity for embedded Power BI. Will this suffice to enforce the security I am looking for? All documentation I am seeing refers to users having pro licenses, but I'd want to avoid this, we have about 1000 users. All they need is consume dashboards for the companies they have access to.

    ------------------------------
    Shilpa Vishwanath
    Architect, Business Intelligence
    Intelligent Hospitality
    ------------------------------



  • 5.  RE: Show slicer selection based on user for non Power BI users(Embedded power BI)

    Silver Contributor
    Posted 6 days ago
      |   view attached
    @Shilpa Vishwanath YES it will.....Prices in GBP Sterling using your Azure PAYG subscription purchase an Azure Power BI Embedded A1 (see picture) license. This along with your 1 developer PBI Pro license will permit your PBI developer to publish his .pbix with Row Level Security (RLS) configured on the dimension 'companies by user'. This architecture will permit you then to use the Power BI Embedded (PBIE) 'App owns Data' model for your external non power bi users to only see the companies they have permissions on.
    Of course this is a PaaS and needs some developer integration of the PBIE into your current app. This includes authenticating your app with AAD, getting an accesstoken and then creating an embedtoken with an EffectiveIdentity.
    I hope that helps yoru research...feel free to ask more if you need....David   ​

    ------------------------------
    David Moss
    Advanced Analytics & Power BI Azure Solutions
    Wottabyte
    London
    ------------------------------



  • 6.  RE: Show slicer selection based on user for non Power BI users(Embedded power BI)

    Posted yesterday
    Thanks for your suggestion @David Moss I will get back if I run into issues while doing this.​

    ------------------------------
    Shilpa Vishwanath
    Architect, Business Intelligence
    Intelligent Hospitality
    ------------------------------