Skip to main content
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Helper I
Helper I

Power Query

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

Expression.Error: We cannot convert the value 2021 to type List.

Super User
Super User

Hi @Rohit001 ,


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

Community Support
Community Support

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,

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

Helper I
Helper I

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

Helper I
Helper I

it is not happening 


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




Yes i do but it is not working

Super User
Super User

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.   

Helpful resources

July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors