Hello all I am stuck on this error, How to resolve this issue
Expression.Error: We cannot convert the value 2021 to type List.
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?
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!
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
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.
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.
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!
130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.