Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

efficiency of Table.SelectRows

when using Table.SelectRows in powerbi, it's soooooo slow. nothins sepci

 

am i alone?

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    It might be your query--what is your Table.SelectRows statement?

  • v-jingzhang's avatar
    v-jingzhang
    Community Support

    Hi Anonymous 

     

    Can you share your Table.SelectRows statement? Sometimes modifying the selection condition or adjusting the order of statements will make it faster greatly. See an example in this thread How to improve speed of lookup query - Microsoft Power BI Community

     

    Best Regards,
    Community Support Team _ Jing
    If this post helps, please Accept it as Solution to help other members find it.