Forum Discussion
M change types
I have code
(strSource, Ip , Port , dBase ) =>
let
Lent = "da",
Source = Sybase.Database(Ip & ":" & Port, dBase),
DBA_view_DidknObj = Source{[Schema="DBA",Item=Lent]}[Data]
in
DBA_view_DidknObj
but got error
An error occurred in the ‘’ query. Expression.Error: We cannot apply operator & to types Text and Number.
Details:
Operator=&
how to convert number to text?
Hi Analitika ,
You can use function Number.ToText to do the conversion.
See the details here:
https://docs.microsoft.com/en-us/powerquery-m/number-totext
Thanks,
Pragati
Analitika , Try like
let Lent = "da", Source = Sybase.Database(Ip & ":" & Number.ToText(Port), dBase), DBA_view_DidknObj = Source{[Schema="DBA",Item=Lent]}[Data] in DBA_view_DidknObj
3 Replies
Hi Analitika ,
You can use function Number.ToText to do the conversion.
See the details here:
https://docs.microsoft.com/en-us/powerquery-m/number-totext
Thanks,
Pragati
Analitika
Try(strSource, Ip , Port , dBase ) => let Lent = "da", Source = Sybase.Database( Text.From(Ip) & ":" & Text.From(Port), dBase), DBA_view_DidknObj = Source{[Schema="DBA",Item=Lent]}[Data] in DBA_view_DidknObj________________________
Did I answer your question? Mark this post as a solution, this will help others!.
Click on the Thumbs-Up icon if you like this reply 🙂
Analitika , Try like
let Lent = "da", Source = Sybase.Database(Ip & ":" & Number.ToText(Port), dBase), DBA_view_DidknObj = Source{[Schema="DBA",Item=Lent]}[Data] in DBA_view_DidknObj
