Power BI Service Limitation

[Chema_Ortega]

Hello everybody,

I need help with two issues, please:

I know there is a 1 GB limitation for the .pbix archive in the Power BI Service. But... what happens if the archive is 900 Mb, but the data set I want to upgrade is greater than 1 GB? Shall I have the 1 GB limitation also, or that limitation only applies to the .pbix archive? If not... Would it be possible with incremental upgrades?

Direct Query: what does mean that there exist a limitation of 1 million rows, but that I can query a 10.000.000 rows data set? It is not very clear for me...

Thanks a lot in advance. Best regards,

Chema Ortega

[Chema_Ortega]

Many  thanks, guys.

Best regards,

Chema Ortega

[ibarrau · Accepted solution]

Hi. Yes there is two limitations on Service with pro account. First 1gb limitation of pbix file and second 120 minutes on refresh time.

If your dataset is 900mb but is growing fast and will be bigger, then it will stop refreshing in the future.

Incremental refresh is a premium feature. If you pay for premium those limitations won't be a problem because they don't exist on premium.

Direct query limitations means it can be broken if you want to show that amount of rows in a calculation, which is difficult. I wouldn't consider direct query unless the source is online and i would use power bi aggregations to cover them.

Regards,

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