Security using Query Parameters Help

[Chanise89]

Good Morning Eveyone, 

I hope someone could provide me with some help on this... 

I currently have a report built out using Direct Query w/ Parameters. That was the requirement so we built it out this way. 

Now I know that RLS is not supported when using Query Parameters. 

However, we have tried to embed the the security piece in the actual query as a parameter to filter the data based on the users ID (see screenshot). 

My question is how would this work exactly? 

Since, I have it embedded in the query, would this work like any other parameter? Meaning, do I have a table with all of the user ids and bind the parameter to the table? If so, how would the data filter when a user logs in? 

Any help or insights will be greatly apprecated! 

[Anonymous · Accepted solution]

Hi @Chanise89 ，

What is your data source?

If it's a SQL Server database, you might consider using the SQL Server Profiler to capture a trace that contains the queries generated during the interaction so that you can visually observe which queries are being sent to the data source.

Dynamic M query parameters.

RLS.

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum