Forum Discussion
Power Bi Report Server
I have a 50GB SSAS Tabular Model. Is it logical to create it in a Power BI report or to connect to the tabular model with a direct query? I am using Power BI Desktop RS May 2025 version.
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.
8 Replies
Hi Bilge,
Thinking about your question, in my oppinion:
A tabular model of 50 GB is extremely heavy for Power BI Report Server. This results in:- High memory consumption: The VertiPaq engine must load the entire dataset into RAM, which can saturate the server.
- Very slow refresh times: Each refresh could take hours and affect other services.
- Limited scalability: Any further growth makes the model even harder to manage.
For these reasons, importing this volume into Power BI maybe could be not the best optionInstead of attempting to load everything into Power BI, consider revising the architecture and adopting a more modern and scalable solution:Use Microsoft Fabric
- Create a Lakehouse or Data Warehouse in Fabric to store the data in an optimised structure.
Alternative with SQL Server
- Expose the data through optimised views or stored procedures in SQL Server.
- Use DirectQuery in Power BI to avoid loading 50 GB into the model.
Official References:DirectQuery in Power BI: When to Use, Limitations, Alternatives - Power BI | Microsoft Learn
If this response was helpful in any way, I’d gladly accept a 👍much like the joy of seeing a DAX measure work first time without needing another FILTER.
Please mark it as the correct solution. It helps other community members find their way faster (and saves them from another endless loop 🌀.
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?
The model is very large and the number of users is high. Is there anything that can be done instead of querying the model?
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.Hi Bilge ,
Could you please let us know if your issue is resolved. If you need any additional help, we’re happy to assist.
Thank you.Hi Bilge , Are you still experiencing any issues? If you need more information or have any questions, please let us know.
Thank You.
