Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hello,
I am exporting excel file from Paginated Report through DAX. The data is coming correctly however, an extra column and row is appearing as a collapsed or hidden column/row after the last column/row. Plwase see the screenshot below where column E and row 7 is coming as a collapsed/hidden column/row.
How can I fix this? The column/row should not be collapsed or hidden but rather come as a standard size.
Solved! Go to Solution.
Hi @Vishruti ,
Firstly I think if the DAX query is extracting other data that is not needed, please consider modifying the query to exclude unnecessary columns or rows. Secondly if you are using PowerBI Desktop, please try refreshing the data and re-exporting the report to see if the problem still exists. If you are using PowerBI Services, check to see if there is an option to adjust the layout before exporting.
I think you can also put the data source in Excel, which can unhide rows or columns and also resize rows and columns, maybe this topic can give you more help: Solved: Excel report displaying additional blank columns (... - Microsoft Fabric Community
Best Regards
Yilong Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Vishruti ,
Firstly I think if the DAX query is extracting other data that is not needed, please consider modifying the query to exclude unnecessary columns or rows. Secondly if you are using PowerBI Desktop, please try refreshing the data and re-exporting the report to see if the problem still exists. If you are using PowerBI Services, check to see if there is an option to adjust the layout before exporting.
I think you can also put the data source in Excel, which can unhide rows or columns and also resize rows and columns, maybe this topic can give you more help: Solved: Excel report displaying additional blank columns (... - Microsoft Fabric Community
Best Regards
Yilong Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
User | Count |
---|---|
85 | |
85 | |
70 | |
68 | |
63 |
User | Count |
---|---|
214 | |
124 | |
117 | |
82 | |
76 |