Restrict Connection to DB2 to Specific Libraries

[magsterrrr1]

Hello, 

We were able to connect PowerBi to our DB2 database, however all Libraries are available to users.  How can we setup connection to allow only to specific libraries? 

Thank you for any assistance!

M

[amitchandak]

@magsterrrr1 , if that is at time creation on connection, then you need control using the user of DB 2.

IF that means secure data rows based on user, Then you need RLS

RLS - Row Level security
https://community.powerbi.com/t5/MBAS-Gallery/Microsoft-Power-BI-Unleash-row-level-security-patterns...
https://radacad.com/dynamic-row-level-security-with-organizational-hierarchy-power-bi
https://www.blue-granite.com/blog/using-dynamic-row-level-security-with-organizational-hierarchies