how to calculate how much cores are enough for 2 TB of data in Power BI Report Server

[max_Dreamer]

Hello Team,

I am new to "SQL Server Enterprise Edition Core Licenses", I have one use case where customer is looking for unlimited on prem Power BI license, so we suggested them to use "SQL Server Enterprise Edition Core Licenses", but now he is asking how much core do I need to purchase if total size of current dataset is 2 TB (might increase in future).

Do we have any calculator or working sheet where we can estimate this is that if you have 1 TB of data then you need x amount of core, if you have 2 TB of data then 2x amount of core.. something like it.

Please expert, need your guidance on priority.

Thanks in adavance.

Regards,

max

[hackcrr · Accepted solution]

@max_Dreamer 

I think you can refer to the following articles, which will guide you to calculate the cores required for your report server:

https://learn.microsoft.com/en-us/power-bi/report-server/capacity-planning

https://learn.microsoft.com/en-us/power-bi/paginated-reports/paginated-capacity-planning

https://community.fabric.microsoft.com/t5/Report-Server/How-to-analyze-datasets-over-2GB-on-powerbi-...

If I have answered your question, please mark my reply as solution and kudos to this post, thank you!