List May be Incomplete Error

[krishb1414]

Hi,

I have to filterout some non using values, so, I m trying to do it but i can't see all my values and it is showing "List may be incomplete". I saw this message many times but after clicking on Load more it will show all values. But Now it is not showing any values and showing "Select all".

anyone help me on this ?

This is how i m getting

[Anonymous · Accepted solution]

Hi @krishb1414,

Any advanced operations or nested m query functions in these steps? AFAIK, they will affect the preview load list due to these expression calculations.

You can also take a look the following link about evaluation models if help for your scenario:

Evaluation model - PowerQuery M | Microsoft Learn

Regards,

Xiaoxin Sheng

[Idrissshatila]

Hello @krishb1414 ,

It may be affected by other columns filter, check the applied steps to see which steps is affecting your result.

try clicking or steps before this step and check if the values would show.

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin