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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Anonymous
Not applicable

Expression.Error: We cannot convert the value 31 to type Text.

I have merged many columns from different files from one folders together. The data of the column of #Days are in numbers and there's also "no offer" in the column. However, I am getting error for "DBS". It says "error" for the #Days for DBS. I am trying to get the numbers. 

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

 

I can't get it to be transferred to numbers. I also have "no offer" in the original excel file. So, I don't know if that could've affected the "#Days" for DBSCapture23.PNG

1 REPLY 1
mlsx4
Memorable Member
Memorable Member

Hi @Anonymous 

 

Have you tried to apply the change type step before merging queries?

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

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