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

[AlexanderAT]

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

[jvanarsdale]

Got me on the right path... thank you!

[BhaveshPatel · Accepted solution]

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