Forum Discussion

selpaqm's avatar
selpaqm
Icon for Helper V rankHelper V
4 years ago

match index with using text not enough memory

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?

Need Help

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    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.