Skip to main content

    Power BI

    Needs Votes

    Refresh/Re-Import PowerPivot Data Model & Measures

    Vote (27) Share
    Patrick Sheridan's profile image

    Patrick Sheridan on 05 Nov 2015 23:04:48

    Need ability to update the Power BI designer file by re-importing the PowerPivot model. If you add new datasources, measures, etc into your PowerPivot model the option to import new sources/measures or a complete refresh would prevent having to rebuild the entire Power BI report from scratch.

    Comments (10)
    Patrick Sheridan's profile image Profile Picture

    abhishek on 05 Jul 2020 23:43:39

    RE: Refresh/Re-Import PowerPivot Data Model & Measures

    Any Workaround for this? BI does not seem to be doing this even now.

    Patrick Sheridan's profile image Profile Picture

    Christoffer on 05 Jul 2020 23:13:21

    RE: Refresh/Re-Import PowerPivot Data Model & Measures

    I agree with below, it would be a valuable and time saving addition to have Power BI update everything from the Powerpivot model upon refresh.

    Patrick Sheridan's profile image Profile Picture

    Power BI User on 05 Jul 2020 22:56:26

    RE: Refresh/Re-Import PowerPivot Data Model & Measures

    Any news on this topic? Seems to be it is still not working :-(

    Patrick Sheridan's profile image Profile Picture

    PRATEEK MANDAL on 05 Jul 2020 22:39:47

    RE: Refresh/Re-Import PowerPivot Data Model & Measures

    Hi All,

    I imported one Power-Pivot model from an Excel file to Power BI desktop (I downloaded it free from Microsoft site). After that I made some modifications to the Power-Pivot model (let's say, a table which had 1000 rows when the Power-Pivot model was imported to Power BI Desktop, now has 1500 rows after modification to Power-Pivot model) and tried to refresh the data in Power BI desktop. The table didn't get refreshed in Power BI Desktop and still shows 1000 rows (not 1500). Is there any resolution to this issue?

    Patrick Sheridan's profile image Profile Picture

    Cyril on 05 Jul 2020 22:33:26

    RE: Refresh/Re-Import PowerPivot Data Model & Measures

    Is there any update on this topic since last year?

    Cyril

    Patrick Sheridan's profile image Profile Picture

    Power BI User on 05 Jul 2020 22:28:30

    RE: Refresh/Re-Import PowerPivot Data Model & Measures

    Agree. Without this feature maintaining a data model proves difficult..

    Christian

    Patrick Sheridan's profile image Profile Picture

    Patrick Sheridan on 05 Jul 2020 22:21:00

    RE: Refresh/Re-Import PowerPivot Data Model & Measures

    just posted this in the desktop section, hopefully will get more attention.

    https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/13718868-update-measures-from-powerpivot-model

    Patrick Sheridan's profile image Profile Picture

    Patrick Sheridan on 05 Jul 2020 22:20:59

    RE: Refresh/Re-Import PowerPivot Data Model & Measures

    Cant believe this still hasnt been implemented. Maintaining several powerpivot models, and also power bi models is becoming less sustainable.

    Need to be able to re-import or update my pbix file from the a powerpivot model.

    Patrick Sheridan's profile image Profile Picture

    Shawn Egan on 05 Jul 2020 22:20:46

    RE: Refresh/Re-Import PowerPivot Data Model & Measures

    this should automatically happen when you hit refresh OR be given the option to refresh from power pivot data model.

    Patrick Sheridan's profile image Profile Picture

    ABOAMAH on 05 Jul 2020 22:19:15

    RE: Refresh/Re-Import PowerPivot Data Model & Measures

    That will be a very great feature to have. Does anybody know a workaround?