Forum Discussion
Appended Queries are Showing null Values
I have 18 spreadsheets that all have the same common column "Sold To Name" I have appended all the spreadsheets together based off the same column name being on all 18 spreadsheets. It says they ...
Hi Anonymous ，
Try the following steps to do troubleshooting:
1. check whether the columns of the two tables you are appending queries with have the same headers,exactly same headers.Otherwise,it will appear null value in the column which doesnt exist in previous table such as below:
2.Check if the null value did exist in previous table.
3.If above cant solve your problem,could you pls show me your sample data,I will test for you.
Best Regards,
Kelly
I doubt that the spreadsheet has empty rows. Can you check each sheet for blanks in powerbi , by filtering for blank or null?