Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Hi,
I have a requriement to show data based logged in user. The logged in user (USERPRINCIPALNAME) need to be passed to query as a parameter user_id to the backend direct query. Data is huge cannot do import mode.
For example --
select sec_lev_grant from table where upper(user_id) = upper('user_id@domain.com')
Thanks in advance
Thank you for the quick response.
What is the fact ?
Here's what I have
yes. dont import your table. and dont use dynamic query. just create a table contains IDs and use it also in import mode and let the relationship do the filtrations
something like the following image
USERPRINCIPALNAME() will filter the dimention that will have a join in your database with the right id
This solution didn't work. Not sure If I am missing anything. Can you please provide more details.
Thank you for the reply. Without dynamic query I am confused how it filters the data.
Is fact a table that we get the results from the query and UserDim is the measure ?
1- create a table contains the user emails in your database
2- make a relationship in power bi datamodel between this table and your fact
3- filter the new table using Row level security.
this will achive your Goal
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
113 | |
92 | |
86 | |
76 | |
66 |
User | Count |
---|---|
146 | |
111 | |
109 | |
103 | |
96 |