cancel
Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Reply
imughal
Helper II
Helper II

File Size Limits - File is too large to upload

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

powerbierror.png

pls also guide what could be other solution.

thx

 

5 REPLIES 5
d_gosbell
Super User
Super User


@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

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 


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

Hi,

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

bradsy
Microsoft
Microsoft

Helpful resources

Announcements
PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors