memory error

[powerbiexpert22]

i am getting below error in table visual, i am using composite model, fact table is in direct query and dimension tables in import mode. this error is occurring when i use column from specific dimension table which is joined with fact table using one to many cardinality and long alphanumeric key example 12345f3abc742g04112ri3b31d96244e. I tried increasing the cache size as mentioned in below blog however it does not help much

https://community.fabric.microsoft.com/t5/Desktop/Memory-error/td-p/2503084

https://community.fabric.microsoft.com/t5/Desktop/While-attempting-to-store-a-string-a-string-was-fo...

[Anonymous · Accepted solution]

Hi @powerbiexpert22 ,

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.

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

Besides, you can also view the following link to learn more information.

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

Use composite models in Power BI Desktop - 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.

[tharunkumarRTK]

@powerbiexpert22 

What is the character length in your text column? if it is greater than the limits then you might this error

Chirs Webb - "there are two different practical limits on the maximum length of a text value in Power BI: the 32766 character limit on text being loaded into Power BI, and the 2.1 million character limit in DAX functions."

Chris Webb's BI Blog: What Is The Maximum Length Of A Text Value In Power BI? (crossjoin.co.uk)

Need a Power BI Consultation? Hire me on Upwork

Connect on LinkedIn

Did I answer your question? Mark my post as a solution!
If I helped you, click on the Thumbs Up to give Kudos. Proud to be a Super User!