How to Integrate Power BI with AD on premises

[henriquesilveir]

Hello guys, i need a help, what i need to do to integrate on premises AD with PBI, to use group policies.

Example: I have 2 two user A and B, user A within Group1 and user B within Group2.

The user A, can access only New York City and B, Toronto.

The point is, i need to garantee this access using the GROUP, not user login, because when i need to add more people in this city, i just need to insert into group AD.

Best Regards,

[v-yuezhe-msft]

@henriquesilveir,

You can configure Row Level Security (RLS) in your dataset following the guide in the article below.

https://docs.microsoft.com/en-us/power-bi/desktop-rls

Regards,
Lydia

[henriquesilveir]

@v-yuezhe-msft Lydia, as i said, i want to integrate with groups in AD. i know about RLS, and i know that i need use RLS to do it too. But, i want to know how to do this integration with RLS + Security groups.

In this article is not cleary for me.

[v-yuezhe-msft · Accepted solution]

@henriquesilveir,

You can check the example in the blog below.
https://www.fourmoo.com/2018/02/20/dynamic-row-level-security-is-easy-with-active-directory-security...

Regards,

Lydia

[henriquesilveir]

@v-yuezhe-msft thank you so much Lydia!