Expression Error We cannot apply operator & to types Text and Number

[Sanju_198222]

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

[7even]

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!

[Greg_Deckler]

@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.