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
FabCon Global Hackathon
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Power BI Monthly Update - October 2025
Check out the October 2025 Power BI update to learn about new features.
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.
