Forum Discussion

Chema_Ortega's avatar
Chema_Ortega
Icon for Helper III rankHelper III
6 years ago
Solved

Power BI Service Limitation

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

Need Help
  • ibarrau's avatar
    ibarrau
    6 years ago

    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.

2 Replies

  • ibarrau's avatar
    ibarrau
    Icon for Super User rankSuper User
    6 years ago

    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.