topic Re: File Size Limits - File is too large to upload in Report Server

File Size Limits - File is too large to upload

Anonymous — Tue, 17 Mar 2020 06:34:15 GMT

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

Re: File Size Limits - File is too large to upload

bradsy — Tue, 17 Mar 2020 22:03:27 GMT

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

Re: File Size Limits - File is too large to upload

d_gosbell — Tue, 17 Mar 2020 22:36:23 GMT

Anonymous 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

Re: File Size Limits - File is too large to upload

Anonymous — Wed, 18 Mar 2020 08:14:34 GMT

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

Re: File Size Limits - File is too large to upload

d_gosbell — Wed, 18 Mar 2020 08:43:33 GMT

Anonymous 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.

Re: File Size Limits - File is too large to upload

Anonymous — Wed, 18 Mar 2020 09:39:30 GMT

Hi,

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