Problem with Power Query RRS feed

  • Question

  • Could anyone help me to fix problem related to Power Query ? 

    As a Query I'm using simple excel file and after when I creating Power Pivot table  figures are counted instead of SUM 

    If I'll use the same excel file and  create Pivot table without using Query there is no such problems and Pivot normally identifying numbers 


    Tuesday, January 12, 2016 9:19 PM


  • Please edit your query and change the type of the relevant column to Whole Number or Decimal Number. You can do it from the Query Editor Home ribbon. Find the drop down Data Type: Any, and select the relevant numeric type.
    • Proposed as answer by greggyb Wednesday, January 13, 2016 12:30 PM
    • Marked as answer by Michael AmadiModerator Saturday, January 30, 2016 11:22 AM
    Wednesday, January 13, 2016 4:01 AM