Forum Discussion
Error 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...
Hi,
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.
Well, it seemed to be an error when changing the data type ine the source table.
Just created a new calculated column with the same calculation, deleted the old one and renamed the new as the old. :catindifferent: