Hi all,

I have imported external data via Power Query, and then transformed the data via Power Pivot in to the data model. I now have the pivot table I need to work on my data. However, is there anyway to export a connection to the data model so I can create pivots in other files?

I don't want to have to copy the entire data model when I want to copy the pivot table - plus I would like to be able to give the pivot table to other users and then update the model centrally.

I have already tried exporting the connection via the [connection-->properties-->definition-->export connection file] however when I tried to import a pivot table from this ODC file it does not allow me to connect, saying it is not recognised.

Any help on this would be greatly appreciated. Thanks,

James