none
PowerPivot Feed OData and JSON

    Question

  • Hello

    I have a simple question, can PowerPivot get the data from a OData feed in json format?

    Monday, December 17, 2012 8:22 AM

Answers

  • it seems that JSON feeds currently must only contain exactly one lists/tables
    opposed to XML where your XML may contain various lists/tables

    in order to work with your list of [Record]s, you first have to convert that list to a table by left-clicking on the column and using "To Table"
    then you can expand that column to get a real table to work with

    hth,
    gerhard


    - www.pmOne.com -

    Monday, September 09, 2013 8:27 PM
    Answerer

All replies