Forum Discussion
Solved
Blank values message
Good afternoon. My report ten times (not always) gives an error when updating saying that it has a blank value in one of my dimension tables. However, there is no blank value in it. So I don't unders...
Hi hudsonvj
Sometimes when you're working with excel files even though the line may look blank but it may contain some hidden information. I prefer to query excel tables rather than sheets.
Something to try is at the end of your imported query, do a "Remove Blank" on the column and see if that fixes your issue.
Hi hudsonvj
Sometimes when you're working with excel files even though the line may look blank but it may contain some hidden information. I prefer to query excel tables rather than sheets.
Something to try is at the end of your imported query, do a "Remove Blank" on the column and see if that fixes your issue.