Forum Discussion
List May be Incomplete Error
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
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
2 Replies
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 👍
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
