Forum Discussion
Helper IPower BI Inheriting Data Types from Microstrategy causing errors
I am not sure about what caused this problem for you, but you can extract the Source data from the errors by adding a new column based on the next formula (put your column name instead of Column1).
try [Column1] otherwise (try [Column1])[Error][Detail]
Hi americanomuerto ,
You mentioned that your document numbers are a combination of letters and numbers, which matches the text/any datatype, you can click on the datatype and then convert it to a text type.
Or you can create a new column and use the Text.From() function to explicitly convert the problematic column to text
Best regards,
Albert He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
- americanomuerto
I tried this first, but since there is no data change step to overwrite, the items remain errors with the same error reason of not being able to convert to numbers.
Unfortunately, Text.From() did not help...
