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

How to get Power BI to use MORE resources

I have a machine with 32 processors, 256GB RAM backed by all flash storage. I am 'getting data' from a 2.7GB csv (approx 41 million rows). PBI is only using like 450GB RAM and 5% CPU. How to I get PBI to consume more resources? It takes a very long time to impor the file (minutes at least)

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User VII
Super User VII

Re: How to get Power BI to use MORE resources

@anotherPassword even though it from 2014, underline power query engine to get CSV files works the same way, you want to explore dataflows and I found that works great.

 

Here another post (most recently) from one fo the most known names. I hope it helps. Don't get caught when the article was written.

 

 

I would  Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.

 

 

 






Did I answer your question? Mark my post as a solution.

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





View solution in original post

3 REPLIES 3
Highlighted
Super User VII
Super User VII

Re: How to get Power BI to use MORE resources

@anotherPassword check this post on the limitations 

 

I would  Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.






Did I answer your question? Mark my post as a solution.

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





Highlighted
Frequent Visitor

Re: How to get Power BI to use MORE resources

That's from 2014. All the articles I find on performance are geared towards PowerBI using too many resources, not how to get it to use all avaialable.

Highlighted
Super User VII
Super User VII

Re: How to get Power BI to use MORE resources

@anotherPassword even though it from 2014, underline power query engine to get CSV files works the same way, you want to explore dataflows and I found that works great.

 

Here another post (most recently) from one fo the most known names. I hope it helps. Don't get caught when the article was written.

 

 

I would  Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.

 

 

 






Did I answer your question? Mark my post as a solution.

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





View solution in original post

Helpful resources

Announcements

August Community Highlights

Check out a full recap of the month!

August 2020 CYST Challenge

Check out the winners of the recent 'Can You Solve These?' community challenge!

Experience what’s next for Power BI

Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.

Top Kudoed Authors