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
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
v-shex-msft
Community Support
Community Support

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

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.
Sean
Community Champion
Community Champion

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.