Power BI Scheduled Refresh Stopped Working

Julia Chu

We have a Power BI report that runs on a scheduled refresh with Blackbaud connector daily. It's worked without issue until last week, the refresh failed with the error that said

“Column 'constituent_lookup_id' in Table 'Constituent (all)' 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. (constituent lookup id (259)).”

There weren’t changed on the Power Query for weeks. I found no “Blank” rows neither id=259 on the referred table column.

Has anyone had the similar issue or any suggestions on how to fix it?

Many thanks.

Julia

Alex Wong

@Julia Chu
constituent_lookup_id “shouldn't” be blank (though this depends on if you did any “join” within power query that may create “empty" value in that column), however, you are not going to be able to find that from within Power BI's table view, as that view only will show you what has “worked”. If your refresh is failing, then your Power BI table view didn't get update and won't see the error row.

You will need to go into Power Query, and then filter on constituent_lookup_id being blank.
= Table.SelectRows(#"Constituent (all)1", each ([constituent_lookup_id] = null))

Julia Chu

@Alex Wong Thank you so much for your input. I was able to remove the empty rows and refreshed the report.

Sincerely,

Julia