Forum Discussion
RDL file size limit when publishing to Power BI Service
- 10 months ago
Hi gb_asc
Yes, there is a 20 MB upload limit for paginated report files (.rdl) in the Power BI Service, this is a known restriction.In order to solve the issue you’ll need to reduce the file size (by trimming embedded images, simplifying queries, or removing unused datasets) or publish the report through a workspace connected to a Premium capacity, where larger reports can be supported.
Did it work? 👍 A kudos would be appreciated
🟨 Mark it as a solution to help spread knowledge 💡
RDL files larger than 20 MB cannot be uploaded. This limit is hard coded and Microsoft has not provided an option to increase it.
How to fix it
Try any of these:
Reduce the number of images
Remove high resolution logos, icons, backgrounds or replace them with smaller versions.Compress or remove embedded resources
Paginated reports often contain hidden embedded images or fonts.
In Report Builder:
View tab > Report Data > Embedded Images > delete unused items.Reduce dataset size
Limit the rows returned by queries.
Use parameters or filters so the report is not pulling unnecessary data.Remove unused subreports or unused datasets
These increase the RDL file size even if they are not displayed.Turn off Keep Together for large tablixes
This sometimes reduces layout metadata.Split the report
If the report is too complex, split it into two separate paginated reports.Convert images to JPEG or PNG and compress before embedding
This alone reduces many RDL files by 50 percent or more.
Bottom line
You cannot bypass the 20 MB limit.
You can only reduce the RDL file size so it goes under 20 MB.