Small and medium business | Business Central, N...

Business Central security filters in permission sets and Power Bi reports

(1) Share

Report

Posted on by AleAlonso

309

Hello,

I have created a permission set allowing users to only see Purchase Orders with Responsability Centre = RES1. I have then created a Purchase Orders Power BI report, when the users goes to this report he is able to see ALL purchase orders. I was expecting to have the permission set security filter applied to the PowerBI report and for the user to see RES1 POs only, but this doesnt seem to be the case. Does anyone know why?

Thanks

Alejandra

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (3)

Answers (0)

Suggested answer

Mustafa Omerbegović 1,473 Super User 2025 Season 2 on at

Like (1)

Report

Hello,

from my experience the security filters in the BC do not automatically apply to Power BI reports, even if the data is pulled from BC. In Power BI, access to data is governed by the security model and roles you define within Power BI itself, rather than the security filters or permission sets in BC. You will need to make changes within your Power BI report to achieve that.

Greetings

Was this reply helpful? Yes No
Suggested answer

Valentin Castravet 31,439 Super User 2025 Season 2 on at

Like (1)

Report

I agree as well, from what I know you have to use row-level security in Power BI. More info here.

Valentin Castravet
Work: Zander ERP Services
Blog: Dynamics 365 Business Central Insights
LinkedIn: www.linkedin.com/in/valentin-c-0500a247/

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 95,640 Super User 2025 Season 2 on at

Like (1)

Report

Or you can add filters directly in the Endpoint, but this requires setting up different connections for different users, which is very troublesome. Not recommended.

Thanks.

ZHU

Was this reply helpful? Yes No

Join the conversation

Community site session details

Business Central security filters in permission sets and Power Bi reports

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > Small and medium business | Business Central, NAV, RMS

Featured topics

Product updates

Community site session details

Business Central security filters in permission sets and Power Bi reports

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Small and medium business | Business Central, NAV, RMS

Featured topics

Product updates