Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon'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.
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!
There are two things you might want to check:
If you can 't figure it out it might help to share your query here.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
15 | |
13 | |
13 | |
12 | |
11 |