Error message _refresh failed

Costa, Mathilde (she, her | elle, elle) 0 Reputation points
2026-05-11T19:50:29.8366667+00:00

An error occurred while processing the data in the semantic model.

Refresh failed: CCMS_NRCan_Funding_by_Province has failed to refresh. Failure details: The last refresh attempt failed because of an internal service error. This is usually a transient issue. If you try again later and still see this message, contact support.

Column '<oii>Line_number</oii>' in Table '<oii>MASTER (INPUT TAB)</oii>' 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. (<ccon>Line number (12618)</ccon>).

Next refresh for CCMS_NRCan_Funding_by_Province is scheduled for May 15, 2026 19:00 UTC.

Not sure what this error means? Any recommendations how to fix this?
Microsoft 365 and Office | Other
0 comments

1 answer

Sort by: Oldest
Most helpful Newest Oldest

  1. AI answer

    2026-05-11T19:50:49.35+00:00

    The error means that column Line_number in table MASTER (INPUT TAB) is used on the one side of a many-to-one relationship (or as a primary key), but it contains blank (null) values. For such key columns, Power BI requires every row to have a non-blank value, otherwise refresh fails.

    To fix it, adjust the semantic model so that the key column has no blanks, or stop using that column as a key:

    1. In Power BI Desktop, open the model and go to Model view.
    2. Locate table MASTER (INPUT TAB) and column Line_number.
    3. Check relationships:
      • Find relationships where Line_number is on the 1 side (the “one” side of a many-to-one relationship) or is used as a primary key.
    4. Fix the data:
      • In Power Query (Transform data), ensure Line_number has no null/blank values:
        • Replace nulls with a valid value, or
        • Filter out rows where Line_number is blank.
    5. Alternatively, change the model:
      • Use a different column as the key that has no blanks, or
      • Change the relationship so Line_number is not on the one side.
    6. Apply changes, republish the report/semantic model to the Power BI service, and run a manual refresh.

    If the refresh continues to fail for other reasons, use the Refresh history page in the Power BI service to inspect detailed error messages and confirm the issue is resolved.

    References:

    AI-generated content may be incorrect. Read our transparency notes for more information.

    Was this answer helpful?

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.