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

[Sunflower7500]

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

I am making edits to the Excel file like adding new columns and adjusting formulas and then saving the updated version of the Excel file to SharePoint.

My issue is that when I try refreshing the semantic model, the new columns and formula in the Excel file are not being picked up. I checked the lineage for the semantic model which gives me the download link to the Excel file which shows all of the new columns and formulas that I added so I am not sure why those changes are not syncing to Power BI.

The semantic models seems to only be picking up the data that was in the Excel file when I originally uploaded it as a semantic model. I tried waiting a few hours between making changes to the Excel file and refreshing the model, but still did not pick up the changes.

How can fix this issue so that it picks up the new columns and any other adjustments to the Excel file? Any help would be greatly appreciated! Thank you!

[ovde]

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.