When specifying your query for importing data into PowerPivot, make sure you columns are unique and only returned once in the query! Otherwise error "Cannot load preview for table "summary1"

Written by Dave Wickert.

User Rating: 5 / 5

Tags: tip