Power Query

[Rohit001]

Hello all I am stuck on this error, How to resolve this issue

Expression.Error: We cannot convert the value 2021 to type List.
Details:
Value=2021
Type=[Type]

[mussaenda]

Hi @Rohit001 ,

You should check your column where you have the value 2021. 

[v-cgao-msft]

Hi @Rohit001 ,

Without knowing the exact context of your code, it’s hard to provide a precise solution.

It seems like you're trying to convert a value of 2021 to a list, which is causing the error. To resolve this issue, you need to make sure that the value you're trying to convert is a list or an iterable object. If you could provide more context or code, I might be able to give you a more specific solution. Could you find the step that returns an error in PowerQuery and give the code?

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

[Rohit001]

I am trying to make a visual like if there is a product in the product column and the next three columns are it's sale, if new data is added to the excel sheet then the visual should refresh and show the latest year's sales 
like present 2021, 2022, 2023 
after 2 years 2025,20

[Rohit001]

it is not happening 

[Dangar332]

You can try to change that column data type to Whole Number or Fixed Decimal Number

[Rohit001]

Yes i do but it is not working

[Dangar332]

it is common error when data type does not mathch with data or it might other problem.  without more detail regarding to this erroe it might tough to resolve problem but you can try to change data type to (Type = Int64.Type) it can help 

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