Data Load Error In Power Bi for 6Cr+ Rows Data Space Issue

[ShahrukhHB]

Hi,
I am Getting Error of Space issue While Loading data.

Data is Huge and Connected With SQL with Limited Columns only,
however i am Getting Error "There's not enough memory to complete this operation. Please try again later when there may be more memory available." After few Minutes this Error comes i Clear Caches As well and Still have more than 10 GB Space in Disc C as well.

Please Guide me how to Fix this issue

[Anonymous · Accepted solution]

Hi @ShahrukhHB ,

Based on the description, the total amount of memory used by one Power BI item can’t exceed the Max memory per semantic model allocation. Each query has max memory limitation.

Modify the query to reduce the amount of data.

Then, try to filter the data in the power query editor before loading.

Besides, you can try to set up incremental refresh policies in power bi.

You can also view the following documents to learn more information.

Incremental refresh for semantic models in Power BI - Power BI | Microsoft Learn

Configure incremental refresh and real-time data for Power BI semantic models - Power BI | Microsoft...

What is Power BI Premium? - Power BI | Microsoft Learn

Best Regards,

Wisdom Wu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[raji_n]

Try disabling any other programs in the background, if you are autosaving files, disable that as well within Power BI nad check @ShahrukhHB 

[ShahrukhHB]

I already done this but Still Error is Same

[raji_n]

@ShahrukhHB check for the calculations, DAX and data model as well and zero out on any specific calculations causing this issue and see if the data loads.

[ShahrukhHB]

Actually I am trying this from last 3 Days. Keep these thing in My mind i simple used 1 table without calculation with sames columns. Eventhen Getting Same Error