Data Modeling Best Practice

[PowerBI123456]

Hi,

I am working with our DBA team to model one of our main fact data sources in our server, which is healthcare claim level data that goes to insurance payers. I am trying to see what the best practice is on how to store data like this for the best power bi performance:

This is how the table looks:

This is what I want it to look like so it can be a star schema and I can connect different dimension tables to it. The problem with this is that it can get into 100billion rows due to the row splits. Should I be worried about row count? If so, what is another way of doing it?

I would appreciate any best tips and best practices. 

Thanks!

[mh2587]

Try waterfall model for details review the following articles 

https://community.powerbi.com/t5/Community-Blog/Data-Modelling-In-Power-BI-Helpful-Tips-amp-Best-Pra...