Forum Discussion
Dynamic User related SQL WHERE clause
Hello friends: I am sure this has been asked before but i could not find a solution. So here goes: We have data in a SQL Indexed View that is grouped inside of the Query Editor. The requireme...
If you're using Import, then the only option is to load all of the data (without user filtering) and then apply RLS as appropriate on that unfiltered data.
lbendlin is correct. Import doesn't allow for dynamic querying, full stop. DirectQuery should work in this scenario, possibly even without needing to write explicit WHERE clauses if table relationships are set up correctly.