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
Ashish_Mathur thanks. i will try it again. that was one of the first things i did prior to putting the thread up
Ashish_Mathur in the end i re-did the whole query and that solved the problem
but on comparison with the new query, all steps are the same but behave differently. anyhow looking good
thanks
- Ashish_Mathur
Super User
Good to know that.