Forum Discussion
Hidden Rows and Columns in Exported Excel
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.