Forum Discussion

elimey's avatar
elimey
Helper I
1 year ago
Solved

connecting to semantic model missing columns

I am connecting to a Semantic Model in PowerBI Desktop, but not all the columns are coming in.  The table in the Semantic model has 25 columns in it, but only 24 is showing up in the Desktop, when I...
Need Help
  • elimey's avatar
    elimey
    1 year ago

    Hi, 
    the issues didn't get resolved. I had republish the report, and start a from zero with the new reprot. 

kushanNa's avatar
kushanNa
Super User
1 year ago

Hi elimey 

 

You will need to contact the person who created the semantic model or the Power BI admin to check if that model contains a hidden column.

If you happen to have permission to download the semantic model, try downloading it and check whether the column is visible. Do not use the Get Data > Power BI Semantic Models method to check if the column is available.

 

elimey's avatar
elimey
Helper I
1 year ago

Hi KUSHANNA

I am the owner of both reports and data sets and nothing is hidden. I have checked it twice.

  • kushanNa's avatar
    kushanNa
    Super User
    1 year ago

    Oh okay, try creating a temporary workspace and refresh the pbix file from desktop and publishing the semantic model there. Then give it at least one refresh before connecting to it again from Power BI Desktop. See if the issue still persists. ?