Vasek

My feedback

  1. 1,022 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    88 comments  ·  Power BI Ideas » Dashboard  ·  Flag idea as inappropriate…  ·  Admin →
    under review  ·  Sirui Sun responded

    Hey all!

    We’ve continued to make progress here, so I wanted to update this thread with our current capabilities for maintaining security on dashboards/reports.

    As always, all of this information can be found in our Row-Level Security (RLS)documentation: https://powerbi.microsoft.com/en-us/documentation/powerbi-admin-rls/

    > If you have set up RLS in Analysis Services, Power BI will send the signed-in user’s credentials to Analysis Services, and respect the RLS rules set up on the on-premises model.

    > Separately, you can set up RLS in Power BI for data sources that you import or connect to via DirectQuery. This process starts in PBI Desktop, where you define roles, and write DAX to constrain what data these roles can see. As part of this process, can you use the UserPrincipalName() DAX function to get the current signed in user’s UPN (e.g. joe@contoso.com). Then, once you publish to service, you can assign users to these…

    An error occurred while saving the comment
    Vasek commented  · 

    to: JD ... I absolutely agree

    Vasek supported this idea  · 
    An error occurred while saving the comment
    Vasek commented  · 

    Can anybody advise me how control the default filter according to the logged-in user

    An error occurred while saving the comment
    Vasek commented  · 

    I tried DAX USERNAME() now, but in Power BI Service it returns "guid" which is the same for all users i our tenant. So this does not work !!!

  2. 140 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    9 comments  ·  Power BI Ideas » Reports  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    Vasek commented  · 

    One thing is add possibility to save my filter/slice for next refresh ... great idea!
    Second one is ability to have in data some parameter about logged (effective) user and use it for default filter/slice. For example when we have nice report for sales team, it would be great immediately to see for every user revenue from “my” customers, my stock value, data of my subordinates etc. Now user must always and always filter “his data” or we have to create dozen similar report for every single user.

    Vasek supported this idea  · 
  3. 210 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    34 comments  ·  Power BI Ideas » Data Sources  ·  Flag idea as inappropriate…  ·  Admin →
    Vasek supported this idea  · 

Feedback and Knowledge Base

Ready to get started?

Try new features of Power BI today by signing up and learn more about our powerful suite of apps.