Forum Discussion

PowerBI123456's avatar
PowerBI123456
Post Partisan
4 years ago

Data Modeling Best Practice

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!