Forum Discussion
Power BI Query
The 1GB limit for import query only applies if you want to publish your report to Power BI Service; otherwise you can have as much data as you want in your Power BI Desktop file. Power BI put a cap on number of times (8 times) you can schedule data refresh automatically per day, but you are free to refresh your data manually as many times you wish.
Hi Shiva799,
So your requirement is to achieve larger refresh frequency and no limitation of dataset, right? The premium license can meet your requirement because premium users can have a dedicated hardware wihch is different from shared capacity. In scheduled refreshes, premium user have no limitation like 8x a day when scheduling refreshes with imported models. In addtion, Power BI Premium gives you the advantage of overcommitting your capacity. For example, you can publish more datasets than capacity memory can hold. If the published datasets in your capacity need more memory than can fit in the capacity, some of the datasets will be stored separately in a persistent storage. The persistent storage is part of 100 TBs storage associated with each of your capacities.
Regards,
Jimmy Tao
Hi Shiva799,
So your requirement is to achieve larger refresh frequency and no limitation of dataset, right? The premium license can meet your requirement because premium users can have a dedicated hardware wihch is different from shared capacity. In scheduled refreshes, premium user have no limitation like 8x a day when scheduling refreshes with imported models. In addtion, Power BI Premium gives you the advantage of overcommitting your capacity. For example, you can publish more datasets than capacity memory can hold. If the published datasets in your capacity need more memory than can fit in the capacity, some of the datasets will be stored separately in a persistent storage. The persistent storage is part of 100 TBs storage associated with each of your capacities.
Regards,
Jimmy Tao