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 / Human Resources forum / Finding Financial Dime...
Human Resources forum

Finding Financial Dimension values in Power BI

(0) ShareShare
ReportReport
Posted on by 40

I'm having trouble finding the Financial Dimensions within the Common Data source API for PowerBI. Can someone let me know what tables they are stored in? And how they link to the Worker Entity

Thanks for any help

Jon

Categories:
  • Verified answer
    Community Member Profile Picture
    on at

    Hello Jon,

    Maintained financial dimensions on (for example) positions or employment, are not available in the CDS.

    Microsoft is aware off this, and looking into options to get this included.

    In order to use this in Power BI reporting, you can create a BYOD integration from Talent, and export the financial dimensions.

    This can be done (for example) done with the data entity 'position default dimensions' .

    If you want to link them to the worker entity, you can either use the employment financial dimensions, or link them to position assignments > position default dimensions. 

    With regards,

    Erik

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 > Human Resources

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans