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

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

Reply
PowerRon
Post Patron
Post Patron

How to handle large datasets: composite model or AAS model?

Hi,

 

we have a few datasets containing each minimal 200GB of data.
We could use a composite model. But in my opinion composite model makes life a little more difficult and whne going to the detailed lverl by using direct query, perfromance might be an issue.

Azure Analysis Services model can handle large datasets and seems to perform excellent.

Does anybody has experience with AAS model ? Would it be a good choice to investigate or are there better options?

regards Ron

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Hi @PowerRon 

Regarding your description, it’s important to consider potential performance implications when using DirectQuery within a composite model. For detailed information, I recommend reviewing the official documentation provided below:

Performance implications

 

For Azure Analysis Services (AAS), it is specifically designed to efficiently handle large datasets, scaling up to manage several terabytes of data. It excels in performance, particularly for complex queries and extensive datasets. AAS processes data in-memory, resulting in fast response times. Additionally, its scalability allows flexibility in accommodating growing datasets. When integrated with Power BI, AAS empowers you to create intricate models while leveraging robust processing capabilities.

Considering your requirements, Azure Analysis Services appears to be an excellent choice for further investigation. However, I recommend conducting performance tests and evaluating costs to ensure alignment with your specific needs. For additional insights, you can explore the following resource:

Migrate from Azure Analysis Services to Power BI Premium or Power BI Embedded - Power BI | Microsoft...

Best Regards

View solution in original post

2 REPLIES 2
PowerRon
Post Patron
Post Patron

Thnx for the extensive answer @Anonymous 

Anonymous
Not applicable

Hi @PowerRon 

Regarding your description, it’s important to consider potential performance implications when using DirectQuery within a composite model. For detailed information, I recommend reviewing the official documentation provided below:

Performance implications

 

For Azure Analysis Services (AAS), it is specifically designed to efficiently handle large datasets, scaling up to manage several terabytes of data. It excels in performance, particularly for complex queries and extensive datasets. AAS processes data in-memory, resulting in fast response times. Additionally, its scalability allows flexibility in accommodating growing datasets. When integrated with Power BI, AAS empowers you to create intricate models while leveraging robust processing capabilities.

Considering your requirements, Azure Analysis Services appears to be an excellent choice for further investigation. However, I recommend conducting performance tests and evaluating costs to ensure alignment with your specific needs. For additional insights, you can explore the following resource:

Migrate from Azure Analysis Services to Power BI Premium or Power BI Embedded - Power BI | Microsoft...

Best Regards

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

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

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.