Forum Discussion
Solved
Expression.Error: We cannot convert the value 1 to type Text. Details: Value=1 Type=[Type]
Hi dear experts, I am facing the following error while appening the data in power query in excel - "Expression.Error: We cannot convert the value 1 to type Text. Details: Value=1 Type=[Type]" ...
Hi, Tanmayjain077 ;
You could try to change 1 to "1",
Or removing Rows that are blank.
Solved: Expression.Error: We cannot convert the value to t... - Microsoft Power BI Community
Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, Tanmayjain077 ;
Is your problem solved? If so, kindly mark the proper reply as a solution to help others having the similar issue and close the case. If not, let me know and I'll try to help you further.
Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.