Skip to main content

Notifications

Announcements

No record found.

Dynamics 365 Community / Forums / Finance forum / Power BI embedded secu...
Finance forum
Answered

Power BI embedded security in D365FO

Posted on by 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.

  • 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... 288,420 Super User 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 Microsoft Employee 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... 288,420 Super User 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.

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 288,420 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,672 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans