Forum Discussion
Power Bi Report Server
Hi Bilge ,
When working with a 50GB SSAS Tabular model and a large user base, direct querying can cause performance challenges. Here are several strategies to help address this.
1. Pre aggregate frequent queries in SSAS so Power BI accesses smaller, faster datasets.
2. Divide the model into partitions, such as by date or region, to focus queries and improve speed.
3. Refresh only updated data instead of the entire model.
4. Use Import mode for smaller, commonly used data and DirectQuery for larger tables.
5. For SSAS Enterprise users, enable scale-out to balance query loads across multiple servers.
Refine DAX measures, minimize calculated columns, and ensure efficient relationships to reduce query time.
Applying these approaches can help maintain your SSAS model's integrity while keeping Power BI performance high for users.
Regards,
Yugandhar.
Thank you for your answer. I am currently using the Olap tabular model with the SQL Server Analysis Services product. I think it would be more logical to connect my model with Power Bi Direct Query?
Hi Bilge ,
Yes, it's best to use Live Connection or DirectQuery. Optimizing the SSAS model for both performance and usability enables Power BI to serve as a strong visualization layer. This approach leverages your existing model, reduces the need for data imports into Power BI, and supports better performance, governance, and management.
Thank You.
The model is very large and the number of users is high. Is there anything that can be done instead of querying the model?