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 ,
Have you already solved the problem? If so, can you share your solution here and mark the correct answer as standard to help other members find it faster? Thank you very much for your co-operation!
Best Regards,
Clara Gong
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.