Solved: Premium Per User Max Query Size

Thigs · ‎04-22-2022

Hi all,

My organization has a P1 Premium license, but it seems I'm running into a model size issue as one of my PBI files is greater than 3 GB (it's about 4 GB). Does anyone know the model size limit for Premium Per User? I can only find total limits, not per model.

SpartaBI · ‎04-22-2022

For Premium 25 GB

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

View solution in original post

SpartaBI · ‎04-22-2022

For Premium 25 GB

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