Exported column with number or text data in PowerBI

[Syndicate_Admin]

Good morning

I exported an Excel table in Power BI. Some columns have numerical or text values and are combined (example: 10001, 3526, ZTIS, ZMMR, etc.).

When I import it into PowerBI it tells me that there are errors and only the numeric fields appear. Where I would have to park the text fields I get blank.

Could anyone help me with the setup? I haven't found what adjustments I have to make.

Thank you

Robert

[AntoineTRICHET]

Hi @Syndicate_Admin 

You probably have a step in your query to determine the type of value in your columns (ChangedType). It is often automatically generated. In your case it probably determines that the data in your column have the type decimal number so the text values are interpreted as errors. Go to Power Query Editor and modify the step #ChangedType to fix your column as any type (see picture below). The other solution is to choose the type text for your column (it will keep both the numbers and the text).

If it solved your issue, please accept it as a solution

[Syndicate_Admin]

Hello Antoine.

I have the columns as an Integer. As you say, PowerBI tries to convert references like "BMCS" into numeric so it gives error.

I try to go change type and I have tried the different options but I do not get anything. Attached image.

[AntoineTRICHET · Accepted solution]

Hi @Syndicate_Admin 

Did you try to delete the step Changed Type and then choose the type text ?

[Syndicate_Admin]

Hello. In excel I have everything as Text and I have reloaded it in Power BI. I am loaded as text but I also get only the numerical formats, those that have text formatting get error.