Patrick Sheridan on 04 May 2016 01:36:40
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.
this was posted under data sources in 11/15, figured I would try posting in the desktop section.
https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/10562640-refresh-re-import-powerpivot-data-model-measures
- Comments (2)
RE: Update Measures from PowerPivot Model
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?
RE: Update Measures from PowerPivot Model
Fully Agree! bit of a waste of time if you can modify your pivot model base with additional measures / changes to current measures. Should be part of the refresh or another option to update measures from loaded model...