Forum Discussion

AlexanderAT's avatar
AlexanderAT
Icon for Helper I rankHelper I
7 years ago
Solved

Refresh problem - "contains blank values and this is not allowed for columns"

Hello   I'm getting this error when trying to refresh my dataset:  Column 'date' in Table 'Budget' contains blank values and this is not allowed for columns on the one side of a many-to-one rel...
Error updating
Help
  • BhaveshPatel's avatar
    BhaveshPatel
    7 years ago

    Hi AlexanderAT,

     

    It would not throw error if you clean trailing and leading spaces in your data in PQ Transformation.

     

     

    Hope this helps.

     

    Thanks,

    Bhavesh

     

BhaveshPatel's avatar
BhaveshPatel
Icon for Super User rankSuper User
7 years ago

Hi AlexanderAT,

 

It would not throw error if you clean trailing and leading spaces in your data in PQ Transformation.

 

 

Hope this helps.

 

Thanks,

Bhavesh