Forum Discussion
Power BI embedded reports fail to render with large dataset
Power BI embedded has different Sku, higher sku has higher compute ability and cost more.
https://learn.microsoft.com/en-us/power-bi/developer/embedded/embedded-capacity#sku-computing-power
The reason why your report time out is probably because the compute needed is more than what you power bi embedded sku can provide, this is proven by the CU usage of 400% you mentioned.
The only solution is to increase the Sku, so that large dataset can be rendered.
Also note that when it comes to limit, there are 2 that you need to be aware of:1. Sku compute limit as a whole ie the 400% that you mentioned
2. Memory limit per semantic model (https://learn.microsoft.com/en-us/power-bi/enterprise/service-admin-premium-workloads#query-memory-limit)
As you increase your sku, it increases the limit for the above 1 and 2
Super UserPower BI embedded has different Sku, higher sku has higher compute ability and cost more.
https://learn.microsoft.com/en-us/power-bi/developer/embedded/embedded-capacity#sku-computing-power
The reason why your report time out is probably because the compute needed is more than what you power bi embedded sku can provide, this is proven by the CU usage of 400% you mentioned.
The only solution is to increase the Sku, so that large dataset can be rendered.
Also note that when it comes to limit, there are 2 that you need to be aware of:
1. Sku compute limit as a whole ie the 400% that you mentioned
2. Memory limit per semantic model (https://learn.microsoft.com/en-us/power-bi/enterprise/service-admin-premium-workloads#query-memory-limit)
As you increase your sku, it increases the limit for the above 1 and 2