Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance forum / Power BI embedded secu...
Finance forum

Power BI embedded security in D365FO

(0) ShareShare
ReportReport
Posted on by Terry Choo 130

For Power BI Content that we can embed into Dynamics 365 FO, how can we apply security to it? 

There is Row-Level Security in Power BI but there are also user roles in D365FO. Can D365FO roles be transferred to Power BI or do we still need to set up RLS in Power BI and add users individually thus doubling the security work?

Thanks.

Categories:
Finance and Operations
Security
  • fehmiktita Profile Picture
    fehmiktita 5 on at
    RE: Power BI embedded security in D365FO

    Hello,

    I encounter the same problem. Did you found any solution to use power bi roles with Finops ?

    Thank you.

    Best regards,

  • DaveCope Profile Picture
    DaveCope on at
    RE: Power BI embedded security in D365FO

    Hi

    Did you mane to resolve this issue - I am at the same stage myself and would be grateful of any tips on to how you achieved passing the security from D365 F&O through to Power BI

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 292,916 Super User 2025 Season 1 on at
    RE: Power BI embedded security in D365FO

    Hi Lobydoys,

    I don't have experience implementing this myself. I only know the theoretical part.

  • Community Member Profile Picture
    Community Member on at
    RE: Power BI embedded security in D365FO

    Hi Andre   Do you have high-level steps for using RLS combined with a AxDB security table?    Also I've used username() function by itself in DirectQuery / Embedded and get a Power BI error of VisualErrorSeeDetails_OpenConnectionError_tableEx.    Does that mean the function doesn't work in this setup?

    Thanks

  • Terry Choo Profile Picture
    Terry Choo 130 on at
    RE: Power BI embedded security in D365FO

    Thanks Andre.

  • Verified answer
    André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 292,916 Super User 2025 Season 1 on at
    RE: Power BI embedded security in D365FO

    Hi Terry,

    When you embed reports, the security from D365 is not applied on the data. So, you need to use RLS in Power BI.

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

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,916 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,782 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156 Moderator

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans