Increase CPU Usage

[AGo]

Hello everybody,

I've got my mashup evaluation container process never going above 10% cpu usage, it's taking hours doing some power query (non foldable in sql) functions. Do you have some hints to make it work faster? I cannot understand where the bottleneck is, RAM usage is low too. My pc is quite powerful, and when uploaded and refreshed through the gateway my model is a lot faster.

Thanks

[v-jingzhang]

Hi @AGo 

There is a "Maximum memory used per simultaneous evaluation setting" in Power BI Desktop. See if this value is set too small. This only affects the working memory on your computer. 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

[aj1973]

Hi @AGo 

What is the source? some sources don't accept Native Queries... 

Power Query is better used for ETL, don't try to do complex calculation with M code, Used DAX for complex calculations.