Power BI Scheduled Refresh Stopped Working

Options
Julia Chu
Julia Chu
Name Dropper First Anniversary First Comment Activity: First Reply
in SKY Developer General Discussions

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

11e0cd967ff801461265a3b42353658f-huge-im
ce9f356afb46190a4b54743c07b8f9f0-huge-im
Tagged:

Comments

  • Alex Wong
    Alex Wong Community All-Star
    Ninth Anniversary 1,500 Likes 2500 Comments Name Dropper

    @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
    Julia Chu
    Name Dropper First Anniversary First Comment Activity: First Reply

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

    Sincerely,

    Julia

Categories