I have a very strange problem exporting paginated report into Excel. The report has a column that shows small icons. After exporting it into Excel everything looks correct except the last row. For some reason the last report row would take two rows in Excel meaning Excel is using merged cells. Who would care but Excel is not sorting data if there are merged cells.
I tried using rectangle wiht an icon inside, same thing. Here is the last Excel row looks like:
All other rows take one Excel row.
This is absolutely crazy. The whole point of the report is the sorting in Excel.
Helpful resources
Power BI Monthly Update - November 2025
Check out the November 2025 Power BI update to learn about new features.
Fabric Data Days
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
FabCon Atlanta 2026
Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
