Forum Discussion

Sunflower7500's avatar
Sunflower7500
Icon for Helper I rankHelper I
2 years ago

Semantic model not picking up new columns added to Excel SharePoint file

Hi everyone,   I have an Excel file (stored in SharePoint) that I uploaded to Power BI service as a semantic model. I am then using that semantic model for a report I am building in Power BI deskto...
Need Help
ovde's avatar
ovde
Icon for Resolver II rankResolver II
2 years ago

There are two things you might want to check:

  1. Are the new columns part of whatever you are importing from the excel? If it is a table the columns might not be included in the range that is imported.
  2. Is your query in the pbi semantic model excluding the new columns in some way? I suspect that Table.SelectColumns or Table.Group or something simular is used. These exclude any columns not included in the functions. 

If you can 't figure it out it might help to share your query here.