Convert Power Pivot data into an Excel table

If you have a Power Pivot data model but want to make some of the information accessible in a row by row listing, this can be done by following these steps:

  1. From the Data menu, within ‘Get External Data’, select ‘Existing Connections’ and go to the Tables tab.
  2. Select your import data option, it can be a straightforward table or you could import as a pivot table or chart.

When producing a summarised MI report, you can use this to also make the detailed breakdown available in a separate worksheet.

Leave a Reply

Your email address will not be published. Required fields are marked *