connecting to semantic model missing columns

[elimey]

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 connet to it. The missing column is not a calculated column. 

Can someone help?

[v-lgarikapat]

Hi @elimey ,

I just wanted to check if your issue has been resolved. If you still have any questions or need help, feel free to reach out I’m happy to assist.

Thank you for being an active part of the community. Looking forward to hearing from you!

Best regards,
Lakshmi

[elimey · Accepted solution]

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

[v-lgarikapat]

Hi @elimey 

Thanks for sharing the resolution  it's really helpful and will surely benefit others in the community. Much appreciated

Best Regards,

Lakshmi

[v-lgarikapat]

Hi @elimey ,

Thanks for reaching out to the Microsoft fabric community forum.

@kushanNa ,

@rajendraongole1 ,

@FBergamaschi 

Thanks for your prompt response 

It's working as expected on my end, where the number of columns is matching between the source (Semantic Medel )and Power BI Desktop.

Could you please try the troubleshooting steps suggested by @kushanNa , @rajendraongole1 , and @FBergamaschi ?

Let us know how it goes we're happy to assist you further if needed.

We truly appreciate your continued engagement and thank you for being an active and valued member of the community.

Best Regards,

Lakshmi

[kushanNa]

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]

Hi @KUSHANNA

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

[kushanNa]

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. ?

[rajendraongole1]

Hi @elimey  - can you open the original dataset in Power BI Desktop.check on  model view and check whether the column is marked as Hidden. if itis hidden, unhide it and republish the dataset.

Hope this information helps.

[elimey]

Hi, 
It is not hiden.

[FBergamaschi]

Can you show some images?

[elimey]

When I look at the Semantic Model on the service, I see all the columns: 

the column that I highlighted is not showing up in the Desktop, when I connect to the model. 
Also, when I reconnect to the semantic model, in the preview section the column shows up, but after connecting, the column is missing 

look at the tabe in the desktop, the column is not showing: