Dataset size over Capacity limit

[gp10]

Dear Community,

I'm seeking advice on handling a challenge where a dataset exceeds the capacity limit (25 GB for P1).

Please take into consideration the following points:

• I've explored all available options to reduce the data model size.
• The dataset is expected to keep growing.
• Utilizing Direct Query on the data source results in poor performance.

I'm particularly curious if any of the new Fabric tools could be helpful in this situation.

Thank you in advance.

.

[Anonymous]

Hi  @gp10 ,

Based on the situation you described, you may consider expanding your capacity. You can refer to the following link to choose the right Capacity for you.

https://learn.microsoft.com/en-us/power-bi/enterprise/service-premium-what-is#capacities-and-skus

How to purchase Power BI Premium - Power BI | Microsoft Learn

If you don't have the budget to expand your capacity, you can only optimize your model on the original data model size.

Optimization guide for Power BI - Power BI | Microsoft Learn

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.

[gp10]

Thanks for taking the time to reply, but as I mentioned above I'm looking for a solution within my current capacity.

[ChiragGarg2512]

@gp10 , PowerBI pro has a storage limit of 10 GB. Upgrading the power bi license should help with this problem.

[gp10]

You can expand the storage limit and for my case you can go up to 25 GBs.
I'm searching for solutions that dont include upgrading Power BI licences.