Business Warehouse Data

[GorD]

Is any one using BW as a source of data for Power pivot?

I'm tring to do this, unsuccessfully

I had two worksheets with BW data and created limked tables, but when i refresh the worksheets and bring in new data it doesn't automatically add to the powerpivot table

Any ideas on how I could do this?

 

[paivers]

It should work. Remember the multiple levels of refresh needed. It sounds like you have your source data in Excel worksheets and are refreshing that. Beyond that you need to go into PowerPivot and refresh the model from that data. Finally you need to refresh the Excel pivot that uses that model. Each is separate to allow you to review before moving to the next stage of aggregation. - Pete