Forum Discussion
Expression.Error: We cannot apply operator & to types Number and Text
Expression.Error: We cannot apply operator & to types Number and Text. Details: Operator=& Left=394838 Right=4274030 let Source = SharePoint.Files("https://sharepoint.com/PowerBiDashboards", [Api...
AlexisOlson
Super User
Super UserI'd guess the issue is in one of these places:
"PK_Plant", each [Site]&[Order Type]&[Product Line]"Item_Order_Line", each [Item Number]&[Order Number]&[Line Number.1]&[Month]Check that each of these columns is a text type prior to attempting to concatenate them as text.