Solved: How to config RLS in Power BI Embed using Node.js

CSpina · ‎06-01-2023

Hi, guys!

I am trying to config the Node.js to use RLS. I dindn´t find any pages teachinh howto do it.

I am using the appownsdata from Microsoft.

Without RLS works fine, but with RLS I receive the error message:

Anyone?

CSpina · ‎06-09-2023

Guys, after burn some fosfate I have fund the solution:

In the file src/embedConfigService.js

Add the lines below after the line 169.

// Add rls
formData['identities'] = [];
formData['identities'].push({
username: '100',
roles: ["Usuario"],
datasets: ["seu dataset"]
})

View solution in original post

CSpina · ‎06-09-2023

Guys, after burn some fosfate I have fund the solution:

In the file src/embedConfigService.js

Add the lines below after the line 169.

// Add rls
formData['identities'] = [];
formData['identities'].push({
username: '100',
roles: ["Usuario"],
datasets: ["seu dataset"]
})

CSpina · ‎06-02-2023

Thanks Pratyasha Samal, but the article is too old and don´t deal with node.js.

pratyashasamal · ‎06-01-2023

Hi @CSpina ,
Please check out this link.
https://medium.com/peritos-solutions/enable-row-level-security-and-embed-powerbi-dashboard-in-an-app...

Hope this was helpful.
Thanks,
Pratyasha Samal
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C