Refresh failed

[PeterJMayes]

For a few weeks both published report and in desktop were refreshing correctly (scheduled in web). Two days ago I started to get failed refresh on the three reports that I had created based on the same data set.

Error being returned in all three reports:

Column '_mcs_commonlocationid_value' in Table 'incidents' 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.

I've checked this column in the Data view and there are no blank records. I checked the relationships in the Model view and this column is not in a relationship with any other table in the model.

Any thoughts would be welcomed.

[ibarrau · Accepted solution]

Hi. That usually an error when you have one blank in a column that is used in a relationship. Try refreshing Power Bi Desktop to see if the error is there. Even if you can't find the blank for that column used in relationship, add a stop in power query editor to "Remove blank rows" for that column. That might solve it.

Hope it helps,

[PeterJMayes]

Hi

Many thanks for the thoughts. Both the online and the desktop refreshes failed. However your response got me to investigate in Query Editor a bit further. Turns out the offending field is not needed in the data model for the report so I removed it. The reports now work without any omissions.

PJ