File Size Limits - File is too large to upload

[imughal]

Hi,

i m using Power BI On-Premises solution and now my file size exceed from 2 GB so while upload report using report server getting following error

pls also guide what could be other solution.

thx

[d_gosbell]

---

@imughal wrote:

pls also guide what could be other solution.

---

For an on-prem scenario you really only have 2 options.

1. Look at reducing the size of your model. You could use the Vertipaq Analyzer tool to help do this. see:
https://guyinacube.com/2019/10/29/quickly-review-your-power-bi-data-model-with-vertipaq-analyzer/

2. You could move your model to an Analysis Services tabular instance and connect your pbix reports to this in live connect mode

[imughal]

with reference to below link, file size upto 10 GB in premium version. Premium On-Premisescan be implemented using SQL Server enterprise edition correct me if wron.

https://docs.microsoft.com/en-us/power-bi/service-premium-what-is#large-datasets

is this applicable to on-premises, how can we set.

Thx 

[d_gosbell]

---

@imughal wrote:

with reference to below link, file size upto 10 GB in premium version. Premium On-Premisescan be implemented using SQL Server enterprise edition correct me if wron.

https://docs.microsoft.com/en-us/power-bi/service-premium-what-is#large-datasets

is this applicable to on-premises, how can we set.

Thx 

---

No that link is clearly for the service (app.powerbi.com) based capacities. It does not apply to the on-premise server which unfortunately has the 2Gb maximum. Mind you if it's structured well you can fit a lot of data into 2Gb. I have a 1Gb file with 250 million records in it.

[imughal]

Hi,

Thanks, can u pls share link / guide how to optimized structured. thx

[bradsy]

File upload is limited to 2gb.  https://docs.microsoft.com/en-us/power-bi/report-server/whats-new#large-file-uploaddownload