Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
We are creating PBI report with data sources in Direct Mode. Row level security has been implemented through some tables. While viewing the report with data security , we could see a lengthy where clause is included in the PBI generated back end query (Snowflake). It seems the where clause is containing values for each records of the result set, but sometimes here they miss certain records and we couldn't identify why those values are not included.
We tried using dynamic parameters and able to see the records are coming in the grid, but we couldn't go with parameters as there are some issues with RLS and multi selection.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi @abipanoor
I can't quite understand your question, can you describe your problem and requirements in detail by sample or screenshot ?
Best Regards,
Community Support Team _ Ailsa Tao