Importing text as null from excel worksheet

[Ricsa]

Hi all,

My report is being monthly actualized with information i gather from different sources into one excel database. I didn´t have any problems before but for this month it is importing a column from the database as "null" instead of the actual text in the column.

That specific column is used for a slicer so instead of having the whole production divided in categories, i have it as a whole in the category "Blank"

The excel doesn´t have any specific format, just "text" and i filled this month information as i did months before so i have no clue of what changed.   The left image shows how it is in the worksheet and how it should be and the right one is from power query importing the text as "null"

.

[Anonymous · Accepted solution]

Consider that two of your Excek columns have the same name (Form.Prod). I bet your M code is looking for a different column name, instead finding the wrong name, and therefore making these values null. 
--Nate

[Anonymous · Accepted solution]

Hi @Ricsa ,

Are the names of the two columns I circled the same? Please try to change to a different column name.

You can clear the data source in the datasource settings and reconnect it.

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous · Accepted solution]

Consider that two of your Excek columns have the same name (Form.Prod). I bet your M code is looking for a different column name, instead finding the wrong name, and therefore making these values null. 
--Nate

[Greg_Deckler]

@Ricsa Tremendously difficult to troubleshoot. Can you provide the code from Advanced Editor? Can you share the Excel file? What happens if you create a brand new query with no operations other than selecting the Sheet (Navigation) step?