export Anaplan data decimals precision to PowerBI

Hi Anaplan Community,

I am trying to export data from Anaplan into Power BI using the Anaplan Connector.

I manage to get my values into PBI, however, I miss the decimals precision which I see in Anaplan.

Example: in Anaplan my number format is set to show 3 decimal places, so 594.450 (US notation), five hundred ninety four (and almost a half)

When I ingest this into PBI and I specify the Data Type to be a Decimal Number, it will only give me 594 (so I loose my decimals).

What am I doing wrong?

I already changed my PBI options, regional settings to English (United States), but that did not resolve the issue.

Do I need to select the checkbox next to "Use digits setting for unformatted exports" in my export action?

Any help is appreciated.

Accepted answers

Dikshant

Not sure but do you have an option to set decimal points in PBI? If Anaplan export is generating decimals with 3 decimal points, then it must be a PBI configuration to ingest 3 decimal point and not round off the number. If Anaplan export itself is not giving 3 decimal points, then we can talk / think of what could have gone wrong and try the option that you mentioned.

All comments

Dikshant

LouiseBourgonjon

it is indeed a PBI setting, regional setting. I set it to English United States so that PBI would read a dot as a decimal separator, but for one reason or another, PBI sets this setting back to English (Belgium), where we use dot as thousands separator. So I believe it is a PBI issue;

Quick Links

Can you help?

Unanswered questions

UX Filter
Hi ALL, I have a module where a line item (Assignments column) is formatted by a large ‘Projects’ list. Each record is assigned to a Project and this module is published to a UX page. When users apply a filter on the Assignments column, the filter dropdown displays the entire Projects list (since the column is…
Dimensionality Issue
Hi ALL, In my model, I have Need stored at a 'D3' RS Group level. I need to use this Need in another module at the G5 Location level. I currently have a mapping module where each G5 Location maps to a D3 RS Group. This Module uses D2 Role as dimension. but the line item I've to find the RS Group (Find D3 RS Group = 'FIND…
Formula to return Connection details...
I couldn't find any formula to do this, but I want a way to put on the page/grid the connection details. This is so I know what connection I'm in rather than going into Connections details to see it. Is there an XL3 formula to return this value?