Jay Killeen

My feedback

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

    We’ll send you updates on this idea

    15 comments  ·  Power BI Ideas » Data Sources  ·  Flag idea as inappropriate…  ·  Admin →
    Jay Killeen supported this idea  · 
  2. 331 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    4 comments  ·  Power BI Ideas » Desktop  ·  Flag idea as inappropriate…  ·  Admin →
    Jay Killeen supported this idea  · 
  3. 216 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    19 comments  ·  Power BI Ideas » Other  ·  Flag idea as inappropriate…  ·  Admin →
    Jay Killeen commented  · 

    I just realised Other User allows you to check against a specific users email. Bugger.

    Jay Killeen commented  · 

    It is interesting that when you click 'View as roles' there is a 'None' and an 'Other user'.
    Other user' is defined nowhere and we don't have the ability to set the rules on it... so why have it? Maybe they are preparing for this feature and allow us to set a rule against 'Other User' that is defined to anyone that has accessed but not yet given a role.

    Jay Killeen supported this idea  · 
    Jay Killeen commented  · 

    I agree with this aswell. It should be something like 'User Level Security' where anyone that has not been assigned a role can have their data scoped down by attributes found on the Username() model.

    For example 'jay.killeen@domain.com' accesses the report and has no role assigned. Behind the scenes PowerBI finds my Username().

    Option 1. Username() inner joins on my User model by matching Username() -> User.email. All other models are inner joined on User therefore all data is then scoped down by the single entity User that has been matched by Username().

    Option 2. Username() itself in AD has fields such as Division, Region or even Role etc and rules can be set (similar to existing RLS Table Filter rules) that utilise the value of these fields.

    Under Option 2 you might have a rule on the Region table that sets Region.Code = Username().RegionCode.

    This way anyone logging in, that has no role assigned could have filters applied based on the User Level Security filters.

    I'd then simply be able to set my rules by user and expect my 1000+ members to be scoped down based on those rules and their attributes can be managed centrally in AD.

    This is how it is done in web frameworks such as Ruby on Rails (see the Pundit Gem or CanCan)

  4. 13 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    2 comments  ·  Power BI Ideas » Dashboard  ·  Flag idea as inappropriate…  ·  Admin →
    Jay Killeen commented  · 

    This idea may solve this problem where you want to set rules across a range of users based on attributes of that user.

    https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/15684009-add-a-default-role-for-row-level-security

    It may circumvent the need to manage the individuals and roles in a CSV for upload.

  5. 6 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    4 comments  ·  Power BI Ideas » Reports  ·  Flag idea as inappropriate…  ·  Admin →
    Jay Killeen commented  · 

    This may be similar to this request where we are trying to get User specific filters for RLS https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/15684009-add-a-default-role-for-row-level-security

  6. 1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Power BI Ideas » Data Sources  ·  Flag idea as inappropriate…  ·  Admin →
    Jay Killeen commented  · 

    You may need to raise a feedback request rather than feature request for this. Maybe try StackOverflow or the PowerBI Community Forums.

  7. 54 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    2 comments  ·  Power BI Ideas » Data Preparation  ·  Flag idea as inappropriate…  ·  Admin →
    Jay Killeen supported this idea  · 
  8. 7 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Power BI Ideas » Data Sources  ·  Flag idea as inappropriate…  ·  Admin →
    Jay Killeen supported this idea  · 
  9. 3 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Power BI Ideas » Dashboard  ·  Flag idea as inappropriate…  ·  Admin →
    Jay Killeen supported this idea  · 
  10. 122 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    7 comments  ·  Power BI Ideas » Data Sources  ·  Flag idea as inappropriate…  ·  Admin →
    Jay Killeen commented  · 

    This would be very valuable for models that have foreign keys for example:

    Tickets that have many users using CreatedById -> UserId. As alias 'Creator' That is the default association.

    Tickets that have many users using AssignedToId -> UserId. As alias 'Worker'.

    Tickets that have many users using UpdatedById -> UserId as alias 'Editor'.

    Jay Killeen supported this idea  · 
  11. 54 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    3 comments  ·  Power BI Ideas » Data Preparation  ·  Flag idea as inappropriate…  ·  Admin →
    Jay Killeen commented  · 

    Is version control important? You don't see it in VBA, you don't see it in Power Query Formula Language. Corrupted workbooks mustn't be an issue for many people.

    Jay Killeen supported this idea  · 
  12. 118 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    14 comments  ·  Power BI Ideas » Reports  ·  Flag idea as inappropriate…  ·  Admin →
    Jay Killeen commented  · 

    Is this in? Pretty sure it is in.

    Jay Killeen commented  · 

    Yeah this seems like such intuitive nature of the user. If I see a pinned tile that says "Users managed by XYZ" and a big count of 10. I want a way to drill down to the filtered table that underlies that tile.

  13. 581 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    46 comments  ·  Power BI Ideas » Desktop  ·  Flag idea as inappropriate…  ·  Admin →
    Jay Killeen commented  · 

    So odd that this is in Power Query but not Power BI Desktop. Doesn't matter. I can't login to the Power Query one anyway :(

    Jay Killeen supported this idea  · 
  14. 38 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    6 comments  ·  Power BI Ideas » Desktop  ·  Flag idea as inappropriate…  ·  Admin →
    Jay Killeen commented  · 

    It has my vote. The current text box takes up room and you also can't adjust the line height which means two lines of 8 font text still takes up a lot of room. I'd love to be able to just add an icon of an 'i' so that when they hover over it some text pops up that adds extra details. The current size of the canvas is so small to begin with to space is precious.

    Jay Killeen supported this idea  · 
  15. 22 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Power BI Ideas » Data Sources  ·  Flag idea as inappropriate…  ·  Admin →
    Jay Killeen shared this idea  · 
  16. 106 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    41 comments  ·  Power BI Ideas » Administration  ·  Flag idea as inappropriate…  ·  Admin →
    Jay Killeen commented  · 

    Ideas include:
    - PQL (PQL or Peequel - )
    - MQL (MQL - M Query Language)
    - M MQL (M Mashup Query Language )
    - PowerM
    - M^ (MPower)
    - M# (M Sharp)
    - #M (But that would break in Twitter :))
    - MIQ (M IQ)
    - MSM (Microsoft M)

    naming things is hard :)

    Jay Killeen shared this idea  · 
  17. 643 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    26 comments  ·  Power BI Ideas » Data Sources  ·  Flag idea as inappropriate…  ·  Admin →
    Jay Killeen supported this idea  · 
  18. 18 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Power BI Ideas » Data Preparation  ·  Flag idea as inappropriate…  ·  Admin →
    Jay Killeen shared this idea  · 
  19. 2,019 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    171 comments  ·  Power BI Ideas » Dashboard  ·  Flag idea as inappropriate…  ·  Admin →
    Jay Killeen 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.