Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

Filter results from SharePoint query in advanced editor

I hav a query collecting records from sharepoint lists. This gives me a lot of results. Now I need to filter the records on the current user. One field returning from Sharepoint is "SP_username".   ...
Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    Anonymous RLS is going to be a "Pro" level feature, which would require all users to have a Pro license.

     

    Based on what you are saying, I really think it is what you are asking to do. Give a look in those links, and if it works out or not comment back so we can explore further or close out the thread for others.

Anonymous's avatar
Anonymous
Not applicable
9 years ago
@Eno1978 wrote:

Anonymous Sounds like you are trying to apply security in the wrong area. Once you pull the data in, then you can assign a role/row level security based on the data in your model. see here

Anonymousactually, I do not try to filter on the records that I own or am authorised to. I try to filter on the records that I am "mentioned" in.

 

I try to explain with an example. In sharepoint somebody creates a listitem, one of the fields of this listItem is "Engineer". This Engineer can be anybody. In power BI I only want to see the records of which I am the engineer. And If "Joe" opens the powerBI dashboard he only wants to see the records where he is the engineer.

 

Thanks, Mike

Anonymous's avatar
Anonymous
Not applicable
9 years ago

I figured it out.

 

#"FilteredTable" = Table.SelectRows(#"Removed Columns", each [HourList.Name] = "j.doe")

 

I have to make this more dynamic but that will not be a big problem.

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    However ;-(

    When I try to do it in some dynamic way, I try this:

     

     #"FilteredTable" = Table.SelectRows(#"Removed Columns", each [HourList.Name] = (Text.End(USERNAME(), (Text.Length(USERNAME() - Text.PositionOf("\",USERNAME())))

     

    This is not working. I'm not sure but I think te USERNAME() function does not work in power query...

     

    Any suggesions would be very welcome