Forum Discussion
Solved
PowerBI refresh timeout in Shared capacity
Hello, I have issue that after couple hours my Semantic model gets timeout in PowerBI service (Shared Capacity). Previously it finishet around in 20-30 minutes. Few times in last months it stuck. B...
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
The issue is likely due to Shared Capacity limitations. To resolve it:
- Optimize Model: Remove unused columns/tables and aggregate data.
- Enable Incremental Refresh: Refresh only new/changed data.
- Optimize Queries: Improve source query performance.
- Upgrade to Premium/PPU: Shared Capacity may lack resources for large models.
- Schedule Off-Peak Refreshes: Avoid refreshing during busy times.
If issues persist, consider splitting the dataset or upgrading to dedicated capacity.