The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
Hello all, I'm a new member and first time poster on this forum.
I am creating a internationalized embedded Power BI report and as part of this I will be using one role for each language that act like this
EnglishRole: [Language] = "English"
SwedishRole: [Language] = "Swedish"
The problem is that when embedding, we already use a role for RLS. When adding one of these new roles none of them work.
The C# code for creating the embed token has this:
var identities = new List<EffectiveIdentity> { new EffectiveIdentity { Username = siteId.ToString(), Roles = new List<string> { "CurrentSite", "SwedishRole" }, Datasets = new List<string> { report.DatasetId } } };
What I've added is the hardcoded "SwedishRole" to the Roles list for testing purpose. After doing that, it doesn't work plus CurrentSite role also stops working with this change.
I have tried putting information in the CustomData element but that was always blank when I wanted to use it in the embedded Power BI report so I have to solve it using one role per language.
Is this a bug or am I using roles the wrong way?
Edit:
Accoring to the docs this should be possible https://docs.microsoft.com/en-us/power-bi/developer/embedded-row-level-security