web
You’re offline. This is a read only version of the page.
close
Skip to main content
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / PowerBi general ledger...
Microsoft Dynamics AX (Archived)

PowerBi general ledger dynamics 365 for operation

(0) ShareShare
ReportReport
Posted on by psidoun 20

Hi all

In previous version of dynamics 365 for operations, ax 2012, there were cubes available to provide reports that were very helpfull for final customer

Most of all General Ledger cube 

I tried to find out similar capabilities with powerbi but I couldn't succeed in

There are some powerbi templates embedded (CFO)  but not matching business requirement

There are some entities when I connect through odata but when I  dig in the list none of them provide previous general ledger cube capabilities

Should this be developped from scratch or do you have any advice or document that can be helpfull

Thank in advance

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: PowerBi general ledger dynamics 365 for operation

    Hi,

    You can get started here on the MS docs site that describes the changes that came into effect with D365FO.

    https://docs.microsoft.com/en-us/dynamics365/unified-operations/dev-itpro/migration-upgrade/in-memory-real-time-aggregate-models

    Best regards,

    Ludwig

  • Suggested answer
    Ajit Profile Picture
    Ajit 8,755 on at
    RE: PowerBi general ledger dynamics 365 for operation

    You can review Aggregate measurements 'FinancialReportingReferenceData' , FinancialReportingTransactionData and all. Go to system Admin - Setup -> Entity Store. you can deploy them in AXDW DB and connect using Power BI.

  • psidoun Profile Picture
    psidoun 20 on at
    RE: PowerBi general ledger dynamics 365 for operation

    Hi Ludwig

    Thanks for your answer but I already went there and the embeded CFO entity I mentioned before is not relevant

    By chance did you implement such requirement for one of your customer?

    Thanks

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: PowerBi general ledger dynamics 365 for operation

    Hello psidoun,

    Here is the equivalent D365FO functionality:

    docs.microsoft.com/.../embed-power-bi-workspaces

    Best regards,

    Ludwig

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

News and Announcements

Dynamics 365 Community Calls Return
Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft
Responsible AI policies for the Community

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Mansi Soni – Community Spotlight

We are honored to recognize Mansi Soni as our August 2025 Community…

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Syed Haris Shah Profile Picture

Syed Haris Shah 9

#2
Mea_ Profile Picture

Mea_ 4

#3
KP-31070522-0 Profile Picture

KP-31070522-0 3

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans