Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
letitbi
Advocate I
Advocate I

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 overloadin memory overload

 

Regards,

Adry

2 ACCEPTED SOLUTIONS
v-haibl-msft
Employee
Employee

@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

hugoberry
Responsive Resident
Responsive Resident

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
hugoberry
Responsive Resident
Responsive Resident

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.

v-haibl-msft
Employee
Employee

@letitbi

 

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

 

Best Regards,

Herbert

Thanks for the tips Smiley Happy

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors