Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi all,
I'm working my way through the various RLS walkthroughs and wondering if the scenario in the subject is possible.
I want to expose power bi dashboards live connected to on-prem SSAS tabular to external users.
My first thought was:
1) Crate SSAS read role set to Everyone membership,
2) make the dynamic row level security table as described in various walkthroughs, set relationship filtering as needed using USERPRINCIPALNAME dax function
3) use power bi UPN mapping to map external user to whatever I want that matches a row in the DRLS table in 2
Will this general idea work? That is: can I really avoid having a on-prem AD account for external users?
Or is there a fault in my logic somewhere and an on-prem AD account is absolutely madatory for the data to flow as I need?
Thanks,
sff
Solved! Go to Solution.
Hi @Anonymous,
You can map the external user to an internal AD user in the data gateway.
Best Regards,
Dale
Thanks Gilbert.
I'd hoped to be able to ninja the whole thing together myself, but I guess getting the internal AD owners involved is the way it has to be then.
Appreciate the tip!
sff
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.