Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Anonymous
Not applicable

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


@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

Anonymous
Not applicable

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 


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

Anonymous
Not applicable

Hi,

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

bradsy
Employee
Employee

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

Top Kudoed Authors