Using an account-based data model in Power BI

Question

I would like to migrate an account-based data model (from SAP Analytics Cloud) to Power BI.

Essentially, all key figures are kept in its own dimension, which contains calculated key figures, hierarchies, aggregation information etc.

What is the best practice to translate this to a tabular model for use in Power BI?

I think hiearachies and aggregations can be handled with DAX functions. However, translating calculated accounts into measures seems to be cumbersome. Moreover, I need to integrate them into the account hierarchy afterwards.

Thanks in advance!

amitchandak · Answer

I think&nbsp;ImkeF&nbsp;, should able to help on this.
&nbsp;
But you might have be very specific about information you need. Also refer :https://radacad.com/build-your-first-star-schema-model-in-action-power-bi-modeling-basics
https://docs.microsoft.com/en-us/power-bi/guidance/

v-yuta-msft · Answer

dp32&nbsp;,
&nbsp;
You can refer to doc below to learn how to build a report in power bi desktop.
https://docs.microsoft.com/en-us/power-bi/desktop-what-is-desktop
&nbsp;
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

dp32 · Answer

Thanks, but I am not a beginner in Power BI, I have already build quite some models.This is really a question to the experts, how to translate an account-based data model.

dp32 · Answer

Thanks, all helpful information, however, star schema is also not the problem. You are right, I should be more specific - and I already asked specific questions in this forum. Such issues like handling of exception aggregations, ragged hierarchies, ragged aggregation formulas, etc.. Bit this topic was just to check if someone else has ever tried this and has some more general modelling tipps.I think we can close this.

imkef · Answer

Hi
I've blogged a bit about these things here:

&nbsp;https://www.thebiccountant.com/2019/10/03/parent-child-hierarchies-with-multiple-parents-in-power-bi-with-power-query/&nbsp;
https://www.thebiccountant.com/2016/07/21/easy-profit-loss-account-scheme-reports-power-bi-power-pivot-dax/&nbsp;
https://www.thebiccountant.com/2017/05/08/dynamic-bill-of-material-bom-solution-in-excel-and-powerbi/&nbsp;
A nice implementation for the typical P&amp;L-problems (mixture of running totals and group totals) with DAX can be found here:&nbsp;https://www.managility.co/profit-loss-dynamic-sub-totals-in-power-bi-excel-dax/&nbsp;

Forum Discussion

Using an account-based data model in Power BI

5 Replies

Related content

semantic model using power bi service

Cannot use composite model functionality (change your model)

Warehouse security when using Direct Lake models

Using Import Models and Dataflows Together

Percentage adjustment based on selecting an account