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!

[SaiTejaTalasila · Accepted solution]

Hi @Sunflower7500 ,

Please refer this video it will help you to fix the issue.

https://youtu.be/7oiTqK47__c?si=U92gnK1dQVch5Zl7

Thanks,

Sai Teja 

[Ray_Minds · Accepted solution]

Hi @Sunflower7500 
I think You can also try  this
1.Check your DataSet connection Properly connected or not
2. Need to check the Share Point Access for that File or Folder where placed the file .
3. Check Your file , your file shoun't Corrupted
4. Go to Transform Data and Open Power Query and check the Transform Step where Remove Other Column step should not there , if there then remove it
For Reference

Remove Other column should remove from the Step

[SaiTejaTalasila · Accepted solution]

Hi @Sunflower7500 ,

Please refer this video it will help you to fix the issue.

https://youtu.be/7oiTqK47__c?si=U92gnK1dQVch5Zl7

Thanks,

Sai Teja 

[Ray_Minds]

Hi @Sunflower7500 
i am suspecting that you have step in your power Query which is selective to few columns and remove any other columns.
Is your power Query looks like below, Source{[Item="RawData",Kind="Sheet"]}[Data], If not then can you please share this line from your Power Query. which remove any other columns

Feel free to reach out if you have any more questions!

If your requirement is solved, please make THIS ANSWER a SOLUTION ✔️ and help other users find the solution quickly. Please hit the LIKE 👍 button if this comment helps you.