Power BI Inheriting Data Types from Microstrategy causing errors

[americanomuerto]

I am connecting to a microstrategy rerport using the Microstrategy for Powerbi Connector. When I pull it over, I notice immediately that one column is giving a lot of errors and is a data type decimal number. In Power Query, there are no steps for changing data types and I have turned that off in the data load section of settings. 

Trying to change the data type to text still causes the errors to continue as it does not replace any data type step. The issue is the document numbers are alphanumeric and can't be converted to number.

What do I need to do to allow me to change the data type to text/any?

I assume it means changing the data type on the microstrategy side, but want to be sure.

[Omid_Motamedise · Accepted solution]

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]

[Anonymous]

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

[OlyaTX]

Unfortunately, Text.From() did not help...

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

[PhilipTreacy]

@americanomuerto 

If you are seeing errors in the column whilst setting up the import I'd be checking those data values in the source to see what the issue is.

If the data is alphanumeric PQ should recognize this and change the column to Any or Text.

What is the data causing the errors?

After loading, click on the word Error in PQ to see what the error message is (2nd image).

Regards

Phil

[americanomuerto]

Hey Phil. Not sure the "What data is causing the errors?" is trying to ask. Here is one example of the error, but most values are two letters followed by ~9 numbers.