Forum Discussion

Asnate's avatar
Asnate
Frequent Visitor
1 year ago
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...
Need Help
  • Asnate's avatar
    Asnate
    1 year ago

    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.

Asnate's avatar
Asnate
Frequent Visitor
1 year ago

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.