I think it is because i am converting a "location Number" to text in powerquery to remove leading zeros then converting it back to a string to concatenate it with another string.
Any help with this is much appreciatied i have a 24 deadline on this
Something went wrong Unable to connect to the data source undefined. Please try again later or contact support. If you contact support, please provide these details. Underlying error code: -2147467259 Table: BI_Locations_DT. Underlying error message: The import Splitter.SplitTextByCharacterTransition matches no exports. Did you miss a module reference? DM_ErrorDetailNameCode_UnderlyingHResult: -2147467259 Microsoft.Data.Mashup.ValueError.Reason: Expression.Error Cluster URI: WABI-US-NORTH-CENTRAL-B-redirect.analysis.windows.net Activity ID: 8af68962-a43e-40f4-bc05-1f8576767214 Request ID: 56f2c37a-676e-9d7c-ef49-6b83cd83c9d1 Time: 2019-06-25 21:39:58Z