Forum Discussion

Gangasaniravi's avatar
4 months ago

Semantic model refresh successful with warnings

Hello All,

 

I am getting a warning for semantic model refresh, 

Warning details

The column '<oii>

Reporting_period_child</oii> [<oii>k_date</oii>]' either doesn't exist or doesn't have a relationship to any table available in the current context.

But in model i don't have table called Reporting_period_child i have Dim_ Reporting Period child and i don't see any warnings/ errors in measures or calculated columns.if i do refresh in website modelling i am not getting any warning.

 

Please help me to resolve this.

 

Regards

Ravi

8 Replies

  • Hi Gangasaniravi,

     

    Thanks for reaching fabric community, will happy to aasist.

    You are facing that warning in the refresh due to the below issues.

     

    Renamed Objects: If you renamed Reporting_period_child to Dim_Reporting_Period_child, some internal references (like a "Sort by Column" setting or an old relationship) might still be looking for the old name. And it is giving the warning.

     

    Orphan Relationships: There may be a hidden or inactive relationship involving the old table name. Even if it is unchecked, the refresh engine still validates it.

    You can have a look at: https://www.youtube.com/watch?v=OyCQqk7DiLc&t=1

     

    Hope this helps, please consdier this as an accpeted solution or give some kusdos.

  • Hi Everyone,

    Thanks for the inputs,

    I checked report there are no errors in measures or calculated columns and hidden tables in model

  • v-dineshya's avatar
    v-dineshya
    Community Support

    Hi Gangasaniravi ,

    Thank you for reaching out to the Microsoft Community Forum.

     

    Hi Natarajan_M , Lodha_Jaydeep  and krishnakanth240 , Thank you for your prompt responses.

     

    It is a Power BI semantic model metadata issue, not a data or report‑level error. some object is still referencing an old table/column name "Reporting_period_child[k_date]", But in your model, the table is "Dim_Reporting Period child".

     

    Please try below workarounds.

    1. Use Tabular Editor: Open model in Tabular Editor --> Search for"Reporting_period_child" and also search for "k_date". You will find it in a hidden measure,  a role,  a sort‑by‑column property,  a calculation group
    and a perspective. Delete or fix the reference.

    2. Power BI Desktop: Check manually the model View, Hidden tables ON, Sort by column on all date/period columns, Manage roles, Calculated tables and Calculation groups.

    3. If you want a clean model, Create a new PBIX, Reconnect to the same source, Rebuild the model (tables + relationships), Copy measures manually and Publish as a new semantic model.

     

    I hope this information helps. Please do let us know if you have any further queries.

     

    Regards,

    Dinesh

    • v-dineshya's avatar
      v-dineshya
      Community Support

      Hi Gangasaniravi ,

      We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. And, if you have any further query do let us know.

       

      Regards,

      Dinesh

      • Gangasaniravi's avatar
        Gangasaniravi
        Helper I

        Hi v-dineshya i have checked all cases no where i can see the the table . I will try building model from scratch or using tmdl