Forum Discussion
BKnecht
Kudo Kingpin
10 years agoError on Scheduled Refresh: Table contains blank values
I have a dashboard scheduled to refresh daily, but each time I get an error that says: "Column in Table contains blank values and this is not allowed for columns on the one side of many-to-one re...
elxaxe
Advocate I
8 years agoHi,
Has anyone solved this?
I'm facing almost the same issue. Error message is: Column '' in Table '' 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.
But this is happening today as yestearday no issue happened. The calculated column that gives this error is calculated like this:
GOAL = LOOKUPVALUE(Services[GOAL]; Services[Case_ID]; Orders[Case_ID])
An GOAL needs to have null values (because newest services aren't estimated yet) and these null values are checked later.
khaled_cs
8 years agoFrequent Visitor
If you process full should work fine , otherwise you always will need to create a new column