web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Business Central secur...
Small and medium business | Business Central, N...
Suggested Answer

Business Central security filters in permission sets and Power Bi reports

(1) ShareShare
ReportReport
Posted on by AleAlonso 311
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)
  • Suggested answer
    Mustafa Omerbegović Profile Picture
    Mustafa Omerbegović 1,477 Moderator on at
    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

     

  • Suggested answer
    Valentin Castravet Profile Picture
    Valentin Castravet 32,390 Super User 2026 Season 1 on at
    I agree as well, from what I know you have to use row-level security in Power BI. More info here. 
     
  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 99,611 Super User 2026 Season 1 on at
    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 1,937 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 1,031 Super User 2026 Season 1

#3
Khushbu Rajvi. Profile Picture

Khushbu Rajvi. 700 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans