Forum Discussion

AGo's avatar
AGo
Post Patron
3 years ago

Increase CPU Usage

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

Need Help
Tips and Tricks
Tutorial Requests

2 Replies

  • aj1973's avatar
    aj1973
    Community Champion
    3 years ago

    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.

  • v-jingzhang's avatar
    v-jingzhang
    Community Support
    3 years ago

    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.