Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Frequent Visitor

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.

Community Champion
Community Champion

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

Frequent Visitor

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

Frequent Visitor

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

Solution Sage
Solution Sage

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

PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors