Forum Discussion

pryorr382's avatar
pryorr382
Frequent Visitor
10 days ago

Model object names must be non empty

I have been tasked with adding another dashboard to a power bi report when I imported the files from a SharePoint site, which by the way is how I have been importing the data from the beginning. I am getting this error model. Object names must be not empty so I've been searching the model and have not been able to find a non-empty object name. Can someone provide some insight to this issue? Thank you

4 Replies

  • Hi pryorr382​ 

    Can you share the error screenshot 

    Error comes from blank or unnamed column or table in source data where a column with no header in an Excel or CSV file or an unnamed sheet or query during SharePoint import. 

    You can check Power Query queries for auto generated columns with blank names like column1, column 2 unnamed sheets

    • ryan_mayu's avatar
      ryan_mayu
      Icon for Super User rankSuper User

      pryorr382​ 

      maybe it caused by blank worksheet or table name; or a blank column header.

      You need to open Transform data to enter Power Query.

      Check the query created for the new dashboard and inspect the Applied Steps, especially: Source, Navigation, Promoted Headers and any custom function used to combine SharePoint files

      if this does not work pls provide your sample data and let us have a try.

  • v-achippa's avatar
    v-achippa
    Icon for Community Support rankCommunity Support

    Hi pryorr382​,

    Thank you for reaching out to Microsoft Fabric Community.

    Thank you krishnakanth240​ and @ibarrau​ryan_mayu for the prompt response.

    As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided by the user's for the issue worked?  or let us know if you need any further assistance.

    Thanks and regards,
    Anjan Kumar Chippa

  • v-achippa's avatar
    v-achippa
    Icon for Community Support rankCommunity Support

    Hi pryorr382​,

    We wanted to kindly follow up to check if the solution provided by the user's for the issue worked?  or let us know if you need any further assistance.

    Thanks and regards,
    Anjan Kumar Chippa