Blank values not allowed for columns on the one side of a many-to-one relationship

[Anonymous]

error message

I have a table with blank values in column 'Faktisk Lukkedato'. Those values are supposed to be blank. The table is not in a relationship to any other tables. It used to be on the many side of a One-to-Many relationship. Not the one side.

So the error indicates that PowerBI thinks the column is the primary key. It is not. I have a column with nice unique values that can be used as primary key.

How do I change primary key? Why does PowerBI think that this excact datetime column is the primary key? There are other datetime columns with no blank values.

no relationships to table

[v-qiuyu-msft]

Hi @Anonymous,

In Query Editor, is there only one table "Alle salgsmuligheder"? Please go to File-> Options and Settings -> Options, uncheck below settings: 

Please try to run the latest Power BI desktop version. 

Best Regards,
Qiuyun Yu 

[Anonymous]

Those settings were already set to no.

And only one table "Alle salgsmuligheder".

[mtaubman]

I am having the same issue with one of my reports.  There are two queries, but only one is loaded to the report.  None of the "automatic" relationship options are enabled, and I get the same error trying to refresh the data.