Forum Discussion

gehe_bbe's avatar
gehe_bbe
Frequent Visitor
3 years ago

High Ram and CPU Consumption with small data

Hi Everybody,   I'm struggling with modelling my Excel file together with Powerquery. I need two "final" tables, one ist SalesData (Sales) the other one ist Amount of Customers in a shop (People). ...
General Comment
gehe_bbe's avatar
gehe_bbe
Frequent Visitor
3 years ago

Hi rubayatyasim,

thank for the suggestion, but keep in mind:

- No change of the steps between Concept 1 and Concept 2 (but change in RAM/CPU usage)

- Very small data, so there ist no need vor incremental refresh

- PowerBI Desktop is no option, it's an Excel-Tool.

Regards Steve

rubayatyasmin's avatar
rubayatyasmin
Community Champion
3 years ago

You can check for these options

  1. Optimize Power Query steps by removing redundancies and using efficient techniques.
  2. Manage query dependencies to minimize redundant calculations.
  3. Disable background data refresh in Power Query Options.
  4. Consider splitting queries or workbooks for complex scenarios.
  5. Monitor and optimize data types for improved performance.
  6. Ensure sufficient system resources and close unnecessary applications.

if my assistance helps you in any way, appreciate the kudos. If solves your problem, accept the solution as the answer. 

 

Thanks