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
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
v-yiruan-msft
Community Support
Community Support

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

Community Support Team _ Rena
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

2 REPLIES 2
PowerRon
Post Patron
Post Patron

Thnx for the extensive answer @v-yiruan-msft 

v-yiruan-msft
Community Support
Community Support

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

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

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

July Newsletter

Fabric Community Update - July 2024

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