Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
@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