Skip to main content

    Power BI

    New

    Refresh/Re-Import PowerPivot Data Model & Measures

    Vote (25) 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

    4d9f1c31 716b-4fdf-b8bb-5299676c36a4 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

    ac38d5ce 186b-457b-a8ca-f58dea5ddbe2 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

    b3e5913c 032e-4375-8386-384005385a67 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

    0b5de1b2 6fe9-4fce-8603-dc020861fd30 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

    208bf79c 836e-44c9-a6ef-ca3b86fb5fa9 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

    34008b05 e7d4-428c-a608-08f0c0fb956c 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

    c851977b 3878-479f-8d51-0c5c68d87d30 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

    c851977b 3878-479f-8d51-0c5c68d87d30 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

    59b20b1b 8850-420f-978f-45ab05378078 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

    aaccc1ed 4563-4fbb-9614-638633c1b86e 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?