Forum Discussion
Expression Error We cannot apply operator & to types Text and Number
Hi Team,
I'm tying to follow the step mentioned to pull financial results of a company listed in BSEindia by following the Youtube video link:(2477) How to Fetch Audited Result of any BSE Listed Company to Excel? - YouTube
via Power Query however I'm getting the Expression Error as "We cannot apply operator & to types Text and Number.
Details:
Operator=&
Left=https://www.bseindia.com/corporates/results.aspx?Code=
Right=532540
I have ceated 2 new Queries as Function so that details are picked automatically.
Unable to resolve please suggest what should be done in this case.
regards
Sanju
2 Replies
Sanju_198222 Make sure that the columns or whatever you are concatenating with the & are both text. Looks like one of them is a number.
I am running into the same error. However, I am stumped because I did not concatenate anything or use the "&" operator. The error shows up on the step where I expanded a merged query.
For context, it was working fine for a while but failed on a refresh after new data was added to the original source.
Any help would be greatly appreciated! Thank you!
