Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.