Forum Discussion
Importing text as null from excel worksheet
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"
.
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.
3 Replies
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?
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.
