Forum Discussion

mahenkj2's avatar
mahenkj2
Solution Sage
2 years ago

Help on optimizing refresh - much more rows than actual rows

I am developing a solution to create match/mismatch list with two set of excel files and it is working perfectly. I do see that while refresh, rows count goes very high from actual data and I am afra...
Need Help
some_bih's avatar
some_bih
Community Champion
2 years ago

Hi 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.

mahenkj2's avatar
mahenkj2
Solution Sage
2 years ago

Hi 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.