composite model use cases

[powerbiexpert22]

what are those use cases when we must go with composite models in power bi?

[Ritaf1983 · Accepted solution]

Hi @powerbiexpert22 

Composite models in Power BI are particularly useful in the following scenarios:

1. Combining Data from Multiple Sources: When you need to combine data from multiple sources, such as a SQL database and an Excel file, composite models allow you to use both direct query and import modes in a single model.

2. Optimizing Performance: If some data needs to be up-to-date (real-time) and other data doesn't change frequently, you can use direct query for the real-time data and import mode for static data. This helps optimize performance by reducing the load on your data sources.

3. Handling Large Datasets: When dealing with large datasets that cannot be imported due to size limitations or performance concerns, composite models allow you to use direct query for the large datasets while importing smaller, more manageable datasets.

4. Enabling Incremental Refresh: For large fact tables that are frequently updated, using direct query in combination with import mode allows you to implement incremental refresh, improving the efficiency of data updates.

5. Leveraging Data Lakes and Big Data: When your data resides in big data storage solutions like Azure Data Lake, you can use composite models to directly query the data while combining it with other imported datasets for more comprehensive analysis.

6. Creating Advanced Calculations: If you need to create complex calculations that are not feasible with direct query alone, composite models allow you to import certain tables and use direct query for others, enabling more advanced data manipulation and analysis.

7. Facilitating Data Security: In scenarios where data security and compliance require that certain data not be moved from its source, composite models allow you to use direct query to keep the data in its original location while still being able to analyze it alongside other imported data.
   
   For more information please refer :
   https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-composite-models
   
   And videos
   https://www.youtube.com/watch?v=m-HOlIb8unshttps://www.youtube.com/watch?v=g-nRxDVt3To

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