Using an account-based data model in Power BI

[dp32]

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!

[v-yuta-msft]

@dp32 ,

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

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]

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.

[amitchandak]

I think @ImkeF , should able to help on this.

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/

[dp32]

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]

Hi

I've blogged a bit about these things here:

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