Max Query Size in PPU

[MaxBacinski1233]

Hi,

I am looking for the max query size for PPU.

but i cannot seem to find this anywhere for ppu.

[Anonymous]

Hi  @MaxBacinski1233 ,

For PPU 100 GB. These limits are per dataset. There is no total limit regarding memory.

Divide these numbers by 2 if these datasets need to be refreshed on the service.

You will probably hit the memory limit in case you have bad performance queries that materalize a lot of data during their execution. More likely to be stopped by the CPU limit rather than the memory limit.

This is the related document, you can view this content:

Solved: What is model size limit in Power BI? And what is ... - Microsoft Power BI Community

Power BI Premium Per User - Power BI | Microsoft Learn

Power BI Premium VS Power BI Premium Per User - Microsoft Power BI Community

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[MaxBacinski1233]

Thank you for your reply v-yangliu-msft.

I find it very hard to believe there is no limit for maximum query size as there are limits on any other tier.

Can you please point to the exact piece of documentation where it says this ?

I have trouble finding even a sentence about this.