Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
When I subscribe to a paginated report to export as a excel file then a made up column is created in excel. I have double checked the paginated report there isn't a blank column. But when I receive my data in a excel file then there is a blank column in the position of column g.
Solved! Go to Solution.
The Excel output sometimes has to insert extra columns and merge cells in order to maintain the position of other report elements. Do you have a text box header or something like this on your report which lines up with this extra column? Typically if I am targetting xlsx as an output I try to keep the layout very simple, with just a single tablix on the page to reduce these sorts of issues.
yes I had a empty title text box which I had to delete thanks for your help.
The Excel output sometimes has to insert extra columns and merge cells in order to maintain the position of other report elements. Do you have a text box header or something like this on your report which lines up with this extra column? Typically if I am targetting xlsx as an output I try to keep the layout very simple, with just a single tablix on the page to reduce these sorts of issues.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
14 | |
4 | |
4 | |
3 | |
3 |
User | Count |
---|---|
14 | |
9 | |
6 | |
3 | |
3 |