custom data connector (with database authentication)

[Sachy123]

we are begining on a new project where I am checking if it is possible to apply security features on the data level with windows loging key?

We have a scenario where we will capture the windows user ID and in the database there is an authentication table which say which users should see what objects in the database. 

Is it possible to pass the windows login information via a custom connector to the database and then only disclose the database objects using the authentication table?

[Gengar · Accepted solution]

Hi @Sachy123 ,

Have you ever considered about RLS? Will this help?

Row-level security (RLS) with Power BI - Power BI | Microsoft Learn 

Power BI Security - Power BI | Microsoft Learn 

Hope this could help you!

Gengar