Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
Sunflower7500
Frequent Visitor

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 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!

1 REPLY 1
ovde
Resolver II
Resolver II

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.

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.