Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
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
@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
File upload is limited to 2gb. https://docs.microsoft.com/en-us/power-bi/report-server/whats-new#large-file-uploaddownload
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.
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!