Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
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
Solved! Go to Solution.
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:
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
Thnx for the extensive answer @Anonymous
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:
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
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
3 | |
3 | |
3 | |
2 | |
2 |