Forum Discussion
Error Message (Blank Values)
If you go in the Query editor and check the column profile?
In this example I have a table with 1100 rows, first 1000 are ok. I the column distribution you'll find no blanksHowever, when switching to full dataset the blank comes out int he profile:
Perhaps you're experiencing something different, but it's already a good check of your data.
Did you select the correct columns to join on in the merge? How do you define a blank for a text colum?
I went to the data (table icon on the left side of PBI Desktop) and then I clicked on the TicketID drop down to check and see if there was a blank value. I also tried text filters by doing "contains..." and then I added space. I do not still see one blank value.
If you go in the Query editor and check the column profile?
In this example I have a table with 1100 rows, first 1000 are ok. I the column distribution you'll find no blanks
However, when switching to full dataset the blank comes out int he profile:
Perhaps you're experiencing something different, but it's already a good check of your data.
Did you select the correct columns to join on in the merge? How do you define a blank for a text colum?