cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
louisvp Regular Visitor
Regular Visitor

High CPU usage Using Datflows in Power BI Desktop

Dear Community,

 

I was very happy to investigate how Dataflows are working.

 

Unfortunately with a Pro License (instead of a Premium License) I am not able to Combine Tables in the Dataflow of Power BI Service.

 

Therefor I connect to Dataflows in Power BI Desktop and merging tables in Power BI Power Query.

 

When I do this, Power Query is using very much CPU and my laptop becomes very slow.

 

It seems that Power Query is constantly connecting the online Dataflow.

 

I Already disabled 'Background data - Allow dat preview to download in the background' and 'Parralel loading of tables- Enable parralel loading of tables' in the option of Power BI Desktop.

 

My questions is : What do I need to do to avoid High CPU usage in Power BI Power Query?

 

Do I need to start using 'Azure Data Lake Storage Gen2'? Or do I need to start using a 'Common Data Model'?


Or do I need to subscribe to a Power BI Premium License (very expensive)?

 

Or is there an other way to combine tables 'In the cloud' so that Power BI Desktop Power Query is working much faster with low CPU usage?

 

I hope someone in this Power BI Community is able to give me a good advise!

 

Thank you very much!

 

Kind regards

 

Louis van Paassen

Agium Finance and Control

The Netherlands

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: High CPU usage Using Datflows in Power BI Desktop

HI @louisvp ,

Please take a look at following link to buffer functions to package advanced operations, they can reduce the spend of system resources on looping calculation:

Speeding up power query (Table.Buffer?)

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |

View solution in original post

4 REPLIES 4
Community Support Team
Community Support Team

Re: High CPU usage Using Datflows in Power BI Desktop

Hi @louisvp ,

I think high CPU usage should more related to your custom merge steps, you can try to remove merge steps to confirm if this issue disappears.

Creating and using dataflows in Power BI

>>Or do I need to subscribe to a Power BI Premium License (very expensive)?

In fact, Premium license not works on power bi desktop client, it is works on power bi service and provide premium capacity to allow you to do share and embed operations.

What is Power BI Premium?

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |
louisvp Regular Visitor
Regular Visitor

Re: High CPU usage Using Datflows in Power BI Desktop

Dear Xiaoxin Sheng,

 

Thank you for your response.

 

In this post I have written some extra information

 

https://community.powerbi.com/t5/Power-Query/Very-slow-WABI-west-EUROPE-d-primairy-redirect-analysis...

 

Could you please advise me what to do to forecome the CPU is going soo high when resfreshing my data in Power BI Desktop?

 

Thanks

Louis van Paassen

 

louisvp Regular Visitor
Regular Visitor

Re: High CPU usage Using Datflows in Power BI Desktop

Dear Xiaoxin Sheng,

 

In you previous reply you asked met to remove merge steps. When I do this the refreshing goes very fast.

 

But when I don't merge tables I am not able to create a model in Power BI.

 

What is you alternative for merging tables ?

 

Kind regards Louis  

Community Support Team
Community Support Team

Re: High CPU usage Using Datflows in Power BI Desktop

HI @louisvp ,

Please take a look at following link to buffer functions to package advanced operations, they can reduce the spend of system resources on looping calculation:

Speeding up power query (Table.Buffer?)

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |

View solution in original post

Helpful resources

Announcements
October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Badges

Incoming: New and Improved Badges

Exciting news: We've given our badges an overhaul and added brand news ones.

Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Top Kudoed Authors
Users Online
Currently online: 204 members 2,344 guests
Please welcome our newest community members: