Forum Discussion

CRE_PBI_Guy's avatar
CRE_PBI_Guy
Regular Visitor
3 years ago
Solved

Data Modeling - When to Use Multiple Data Models?

All, Forgive me in advance if already addressed; I don't really know the phrase to search for an answer to my question, which is as follows:   Background:  I work in commercial real estate (CRE) w...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi CRE_PBI_Guy ,

     

    According to your statement, I think your issue is that there is large amount of data in your data model and this will cause the bad performance in Power BI.

     

    As far as I know, if there are multiple category part data as you mean like economic forecasts, interest rates, census incomes and so on which are not associated and no comparison will be made. Then you can create multiple Power BI reports to show them.

     

    If you need to create a report with large size data, import connection mode may be not a good choice. I suggest you to move your data into data sources which support DirectQuery or Live connection mode. DirectQuery will only load metadata into Power BI and Live connection mode needs you to create data model in data source and won't load any data into Power BI.

     

    You can refer to this offical blog to learn more details about how to optmize your data model.

     

    Best Regards,
    Rico Zhou

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi CRE_PBI_Guy ,

 

According to your statement, I think your issue is that there is large amount of data in your data model and this will cause the bad performance in Power BI.

 

As far as I know, if there are multiple category part data as you mean like economic forecasts, interest rates, census incomes and so on which are not associated and no comparison will be made. Then you can create multiple Power BI reports to show them.

 

If you need to create a report with large size data, import connection mode may be not a good choice. I suggest you to move your data into data sources which support DirectQuery or Live connection mode. DirectQuery will only load metadata into Power BI and Live connection mode needs you to create data model in data source and won't load any data into Power BI.

 

You can refer to this offical blog to learn more details about how to optmize your data model.

 

Best Regards,
Rico Zhou

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.