Forum Discussion

lombardit7's avatar
lombardit7
Regular Visitor
9 years ago

Best Practices for PowerBI/Power Pivot Integration?

First time poster here. I have a marketing report i've built for a client that integrates 22 sources of data using PowerQuery (Get and Transform) to bring in, clean, and load to PowerPivot. In PowerP...
v-huizhn-msft's avatar
v-huizhn-msft
Microsoft Employee
9 years ago

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

Davidataylor102's avatar
Davidataylor102
New Member
9 years ago

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.