locked
Data Accuracy RRS feed

  • Question

  • I have imported data from SQL table using Powerpivot and used Chart to display the data. I used a query to import the same data and chart to display the data but the results are different. This time I created a view to import same data and the results are different again. Why is that I never get same results when the same data is imported in different ways?
    Thursday, June 3, 2010 9:21 PM

Answers

  • As long as the data have remained constant, the values should be the same. The only place I would expect to see differences would be in the way in which rows are ordered in the PowerPivot table as compared to the source relational table or view. That is because of the way that we compress the data.

    HTH

    John Desch

    Friday, June 4, 2010 2:49 PM