Forum Discussion
Best Practices for PowerBI/Power Pivot Integration?
Thanks v-huizhn-msft!
I can be more specific with my questions:
- Once I import a data model into Power BI, is there anyway to "refresh the model", so that any new measures, queries, relationships created in PowerPivot can be added into my Power BI workbook?
- If not, it seems to me that I am forced to commit to Power BI for any additional modeling or querying once i've created a new report. Otherwise, any changes I make to my Power Pivot data model, would need to be mirroed in Power BI, or I would need to create a new report and import the updated data model...and rebuild all of my visualizations.
Thanks!
Tim
Hi lombardit7,
If your data source is changed, you can Click the refresh in date model window like the highlighted in following screenshot.
But any new measures, queries, relationships created in PowerPivot cann't be added into my Power BI workbook. You should rebuilt them. You can create copy->paste in the formula editor catelog. Then create a new report.
Best Regards,
Angelia
I am having this very same issue. I compiled all my data into txt documents, then used Power Query (Excel 2013 user still) to bring it into Power Pivot. I then created several measures and calculated columns and relationships. Then, I imported this data model into Power BI and began tinkering with the reports. BUT, when I then had to build a new calculated measure back in Power Pivot, I could not refresh Power BI - indeed, it wanted me to start from scratch!
I could be mistaken, but i think that Power BI wants you to query source data to be used as a substitute for Power Pivot. You can make your calculated measures in Power BI.
BUT, it sucks that the two don't really talk to each other; at least, that is what i have frustratingly found so far.
Hi
Refresh doesn't work, can see the Excel File in Power BI but acutal changes are not reflected in the Reports.
How to proceed?
