match index with using text not enough memory

[selpaqm]

Hi,

I am using below formula in excel and working well for finding cell that contains specific part of text.

=INDEX(AAA!R:R,MATCH("*"&BBB!H159&"*",AAA!U:U,0)

however, In power BI, using containsstring is caused not enough memory issue. (table row number almost 500k, coloumn number is around 20)

so what else I can apply on it?

[Anonymous]

Hi @selpaqm ,

Please go to File --> Options --> Current File --> Data Load-->

1. Clear caches

2.Try increasing the Maximum allowed(MB)

3.Turn off Background data.

4.Refer to this blog about  Optimization in Power BI

5.Do the steps in Excel and then import the .xlsx file to Power BI.

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

[AlexisOlson]

What's the DAX expression you're using with CONTAINSSTRING?