Forum Discussion

AlexanderAT's avatar
AlexanderAT
Helper 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 relationship or for columns that are used as the primary key of a table. Table: Budget.

 

I have tried everything I could find on the forum, importing the "budget" table to my report again and nothing is working - and there is no blank in the data to start with.

Furthermore, there is no problem when I refresh the data on the desktop version and I can upload it fine.

 

All suggestions are welcomed 

 

Alexander

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

     

2 Replies

  • BhaveshPatel's avatar
    BhaveshPatel
    Super 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