Forum Discussion
Which credentials are used when using direct query
We are using a data warehouse type data source, which has user-specific security. This means that Person A and Person B may see different tables when viewing this warehouse based on their individual...
Yes your understanding is correct.
There are two options you must consider
Option 1:
Enforce Warehouse Level Security, like User A can see the table / User B should not be allowed to see the table
This option is only applicable if Power BI can get the viewers identity level secrets from Warehouse.
Option 2:
Enforce RLS or OLS at Power BI that is the best approach to go for.