Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
CRE_PBI_Guy
Regular Visitor

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) where I have access to numerous resources, both internal and external.  For example, we use economic forecasting services, CRE sales and forecasting vendors, REIT-derived information and forecasting, internally maintained database of transactions, census data, geo-tagged news articles, etc.  The goal of our PowerBI project has been to consolidate all of these resources within the PowerBI ecosystem (through table importation, API's, links to MS Lists, etc), which we have done.  However, when you start adding to the already-robust underlying census tract data, millions of datapoints from a variety of different sources (some with data back to the 80's), PowerBI gets a little sluggish.  

 

Question:  So, this begs the question:  Is there a general rule of thumb people use when creating a data model (or, as I refer to it, a single .pbix file) where it makes more sense to break it down into multiple files?  This is obviously less ideal, as it requires flipping back and forth between models, but it's not horrible as we use MS Teams for daily workflows (i.e. you can have a couple of tabs linked to different models within teams, which isn't too cumbersome).  As an example, instead of having economic forecasts, interest rates, census incomes, supply pipeline, sales comp transactions, historical market performance, geotagged news articles, etc....all in one file, or would it make sense/is it best practice to break each topic into it's own .pbix file?

 

I believe you can maybe even reference visuals in other data models if you need to as well?  Might this be a better solution?

I really am aiming to increase the 'snappiness' of PowerBI for my colleagues who may or may not have powerful laptops.

 

TIA

 

1 ACCEPTED SOLUTION
v-rzhou-msft
Community Support
Community Support

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.

View solution in original post

1 REPLY 1
v-rzhou-msft
Community Support
Community Support

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.

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.