Forum Discussion
Expand excel table but limit columns
looking for way to improve the performance of a PBI report that brings in an excel table by limiting the columns at this stage when i create the steps to find the file and excel worksheet, i need...
Hi,
Why is it fetching columns which are blanks into the Table? My guess is that there is formatting lying in the cells which look like blank cells to you.. Please open the source Excel file and delete the empty rows and columns. Save the file and close the file.
Ashish_Mathur thanks. i will try it again. that was one of the first things i did prior to putting the thread up
PhilipTreacy
Super User
Super UserHi Anonymous
When you click on the double headed arrow to expand the table, you get the choice of what columns to expand. Can't you use that to limit the columns that appear?
Regards
Phil
PhilipTreacy
thanks, yes that could do it
though the list of columns goes upwards to 16380, is there a way to dynamically do that without having to click on 15800 select boxes?