Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
I have a few dashboards built to show sales, revenue, expenses, usage etc , I need to build an access control for these dashboards
High-level requirement access is
And below is the sample table of product, region and location.
Product | Region | Location |
TV | America | Texas |
TV | America | New York |
TV | Europe | Germany |
TV | Europe | Italy |
TV | Greater China | Shandong |
TV | Greater China | Zhejiang |
TV | Japan | Tokoyo |
TV | Japan | Kyoto |
TV | Rest of Asia | India |
TV | Rest of Asia | Singapore |
Mobile | America | Texas |
Mobile | America | New York |
Mobile | Europe | Germany |
Mobile | Europe | Italy |
Mobile | Greater China | Shandong |
Mobile | Greater China | Zhejiang |
Mobile | Japan | Tokoyo |
Mobile | Japan | Kyoto |
Mobile | Rest of Asia | India |
Mobile | Rest of Asia | Singapore |
So I am planning to design the roles as below
But these would end up creating too many roles and also will have operation maintenance issues when a new product is added.
is there a simple way in power-bi space to build ACL for these kinds of requirements?
You should be able to achieve this using PATH and USERPRINCIPALNAME functions. See RADACAD article here for more details Dynamic Row Level Security with Organizational Hierarchy Power BI - RADACAD