Forum Discussion
PowerBI refresh timeout in Shared capacity
At first I tried Model optimization, Query optimization etc. Also considered incremental refresh. But all that didn't help since id doesn't load at all then incremental refresh wans't an option.
In the end the problem was multiple calculated colums on a large table. After moving them to Data import steps, it worked like a charm. It seems that PowerBI is hard to manage RAM resource limitations during those calculated column refreshes.
Hi Asnate ,
Thanks for reaching out to the Microsoft fabric community forum.
rohit1991's answer correctly addresses solutions to optimize refresh times and performance in Shared Capacity and key solutions include model optimization, incremental refresh, and considering an upgrade to Premium or Premium per User. Additionally, here are other known limitations of Shared Capacity.
- In Shared Capacity, resources are shared among multiple customers, potentially causing slower performance and timeouts during high usage.
- In Shared Capacity, Power BI faces CPU and memory limits, which are lower than those in Premium or PPU.Complex models or high data volumes can lead to longer refresh times, especially during peak periods.
- It has a queue for data refreshes. High user activity can delay or timeout your dataset refreshes due to resource limits, causing slow performance.
- Even though your model is under 1 GB, complex or inefficient queries, large data imports, or complex transformations can strain Shared Capacity resources and cause timeouts.
I am including a resolved thread related to Pro License (Shared Capacity) vs Premium License (Dedicated Capacity). Please refer to it for a better understanding:
I hope my suggestions give you good ideas, if you need any further assistance, feel free to reach out.
If this post helps, then please give us Kudos and consider Accept it as a solution to help the other members find it more quickly.
Thank you.
Hi Anonymous ,
I have a question regarding this point: "In Shared Capacity, resources are shared among multiple customers, potentially causing slower performance and timeouts during high usage."
Is it possible to know if more limitations were added in Shared Capacity? if the resources in Shared Capacity are less than a month or if for the same resources more customers are competing for?
Hi mcaraballo ,
Thanks for reaching out to the Microsoft fabric community forum and for actively participating in the community forum and raising a queary in the community forum. Your contributions make a real difference.
As per your question I am inculding you a similer thread which is already resloved so kindly refer to that for better usdersting:Solved: Shared Capacity Workspace Limits - Microsoft Fabric Community
Thank you.