Forum Discussion
Solution SageHelp on optimizing refresh - much more rows than actual rows
Community ChampionHi mahenkj2 do not import all the columns which you do need for your model / queries.
Analyse which columns you need and only import them.
Backup your working and pbi files and play a bit with decreased number of columns to figure out what columns are not needed.
Maybe the best would be to create some query out of pbi and then import the Excel file which you think will grow / be needed in future.
Solution SageHi some_bih
I do have couple of additional column for future usage possibitlity, these have just 1 or 2 unique values in each column. I do see little improvement in performance. I would expect if there are some alternate means to reduce total rows processed during query processing or some alternate ways to handle such application.
Secon solution you suggest is not possible in my case.