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

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

Reply
lombardit7
Regular Visitor

Can you refresh a data model

Here's the scenario:

  1. I created a data model in Power Pivot - connected to 22 queries, relationships are built out, measures have been added. 
  2. I imported that data model into Power BI - everything transferred over correctly. 
  3. As I am building out the report in Power BI, I realized that I need to add a few new measures. Easy enough to do in Power BI, but now there is a discrepancy between my Power BI data model and my Power Pivot data model. 
  4. Here's my question: Is there a way to "refresh" the data model I already have imported into Power BI? So, if I need a new measure, I can add into Power Pivot first, and then refresh the Power BI report?
  5. Otherwise, I am forced to either make the same change twice in both models, or create an entirely new report with the updated Power Pivot model.
  6. Yes, I realize that I can "detach" myself from the Power Pivot model and use Power BI, but I plan on adding in several new queries over the next month or so, and don't feel Power BI is equipped to handle the entire ETL and Data modeling process.

Thanks in advance!   

2 REPLIES 2
Anonymous
Not applicable

Hi @lombardit7,

 

Based on test, current power bi desktop not support this feature, you need to re-import from power pivot. (The refresh function only refresh the data not the data model)

 

For your requirement, you can vote below ideal:

Refresh/Re-Import PowerPivot Data Model & Measures

 

Regards,

Xiaoxin Sheng

Sean
Community Champion
Community Champion

Helpful resources

Announcements
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors
Top Kudoed Authors