Forum Discussion
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".
So in de the advanced editor I would like to do somethink link. "Filter records where USERNAME() = "SP_username".
I tried to do something like "#"Filtered Rows" = Table.SelectRows(dbo_ConditionTimeline, each [COLUMNNAME] > #date(2014, 1, 1))"
This is not working in my case. I think because I have a Json result.
Can someone help me out?
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.
7 Replies
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
@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