Dynamics Community Forum Thread Details

Add financial dimension values to the Trial balance Power Bi report

Hi All
I need to add a financial dimensions to the PBi Trial balance report. Out of the box this requirement is not implemented, but there is a way to add a separate column for each FinDim in the DimensionAttributeValueCombination table (this table (each FinDim in a separate column) is going to be used in the PBi report)

https://learn.microsoft.com/en-us/dynamics365/fin-ops-core/dev-itpro/financial/dimensions-overview

There is an out of the box report: General ledger / Workspaces / Financial analysis – all companies

In the PBi desktop app the data model looks like this: the Dimensions data source (which is the FinancialReportingTransactionDataV3_DimensionCombination view in the AxDW)

And when I add any FinDim that I need (for instance the OfficeVal) - it's not visible in the report, but at the same time it's visible when you switch to the Table view.

I assume that this type of Visuals (I mean - the report itself, which is at the left top corner of the screenshot), so, this Visual - is something that specific to the D365 (just see the icon - green rectangle) - su0ch Visual, does not exist in the standard PBi desktop - I assume because of this Visual, PBi does not allow to add any string value. Maybe I'm wrong, and maybe you know another solution, any help is appreciated