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

Power BI in-memory RAM = Overload

Hi,

 

I'm facing a problem while trying to get data from "OData Connector", trying to get a 100M+ rows dataset.

After 45M rows loaded my RAM is overloaded (see screenshot).

 

How to analyze a high volumetry dataset ? (looking for both free and paid options)

in-memory-overload-powerbi.pngin memory overload

 

Regards,

Adry

2 ACCEPTED SOLUTIONS

Accepted Solutions
Microsoft v-haibl-msft
Microsoft

Re: Power BI in-memory RAM = Overload

@letitbi

 

You can try to use Direct Query instead of Import mode, or try to add extra memory for your computer.

 

Best Regards,

Herbert

View solution in original post

Highlighted
hugoberry Member
Member

Re: Power BI in-memory RAM = Overload

In order to reduce the amount of RAM your Data Model uses you must consider casting the columns to the appropriate data types. Very often a forgotten text column  which actually represents a number would consume all of your RAM in no time.

Also worth mentioning that the data types that you have in your data model are not necessary reflective of those that you get in your query. That is why checking how your data is structured in your Data Model is a quick win for RAM consumption.

 

Secondly, depending from where you get your data from you consider changin your M Query. The quick wins here are streaming the data or if you are making any intensive calculations in your queries  Buffer the intermediarry steps.

 

And finally consider loading the data one query at a time.

View solution in original post

3 REPLIES 3
Microsoft v-haibl-msft
Microsoft

Re: Power BI in-memory RAM = Overload

@letitbi

 

You can try to use Direct Query instead of Import mode, or try to add extra memory for your computer.

 

Best Regards,

Herbert

View solution in original post

Highlighted
hugoberry Member
Member

Re: Power BI in-memory RAM = Overload

In order to reduce the amount of RAM your Data Model uses you must consider casting the columns to the appropriate data types. Very often a forgotten text column  which actually represents a number would consume all of your RAM in no time.

Also worth mentioning that the data types that you have in your data model are not necessary reflective of those that you get in your query. That is why checking how your data is structured in your Data Model is a quick win for RAM consumption.

 

Secondly, depending from where you get your data from you consider changin your M Query. The quick wins here are streaming the data or if you are making any intensive calculations in your queries  Buffer the intermediarry steps.

 

And finally consider loading the data one query at a time.

View solution in original post

letitbi Frequent Visitor
Frequent Visitor

Re: Power BI in-memory RAM = Overload

Thanks for the tips Smiley Happy

Helpful resources

Announcements
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

January 2020 Community Highlights

January 2020 Community Highlights

Make sure you didn't miss any of the things that happened in the community in January!

Difinity Conference

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Solution Authors
Top Kudoed Authors