cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Helper III
Helper III

Refresh pulls new data into reports, but does not see newly created measures/KPIs

Hi PBI lovers,

 

I've uploaded an Excel file with a table in a spreadsheet, which is a linked table in the data model. I created one measure in the data model before I uploaded it to PowerBI.com. The data set appears, and I can create visuals, edit the table in Excel, and refresh to see the new data reflected in my reports, that's great! But, if I add a new measure or KPI to the Excel file (hosted on OneDrive for business) after the initial upload, refresh does not see those changes in the data model, only new data in the table. Anyon else experience this?

1 ACCEPTED SOLUTION

@Sicilian This is expected behavior. The refresh will only update data, not model objects. You would need to republish the data set in order for structural changes to be applied.


Looking for more Power BI tips, tricks & tools? Check out PowerBI.tips the site I co-own with Mike Carlo. Also, if you are near SE WI? Join our PUG Milwaukee Brew City PUG

View solution in original post

2 REPLIES 2

@Sicilian This is expected behavior. The refresh will only update data, not model objects. You would need to republish the data set in order for structural changes to be applied.


Looking for more Power BI tips, tricks & tools? Check out PowerBI.tips the site I co-own with Mike Carlo. Also, if you are near SE WI? Join our PUG Milwaukee Brew City PUG

View solution in original post

OK, just wanted to be sure I wasn't missing something. 

 

Thanks for the reply, Eno!

Helpful resources

Announcements
secondImage

Experience what’s next for Power BI

Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.

secondImage

Power BI Women

Join our monthly meetings and learning sessions.

secondImage

Congratulations!

We are excited to announce the Power BI Super Users!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors