Power Query Editor Returns All Null Values in a Column when Data Exists in JSON


  • My environment:
    Excel 2016 + Windows 10 running under VMWare Fusion 11.

    My problem: I use Get Data -> From File -> From JSON to import a JSON file and launch the power query editor. I then use the power query editor to drill down into the data and select the desired columns. Some of the columns contain null in all the cells in the column even though there are values in the JSON data file. There are about 800 rows of data in the file. Any ideas?

    Thanks, Tom P

    • Edited by TPloski Friday, May 17, 2019 1:09 AM Typo
    Friday, May 17, 2019 1:08 AM