Forum Discussion
How to handle large datasets: composite model or AAS model?
Hi Anonymous
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:
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:
Best Regards
Hi Anonymous
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:
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:
Best Regards