Monday, August 7, 2023

Extract or Parse JSON Data with Power Query


Did you know Power Query can talk JSON? Well no they don’t actually talk to each other….but if you’re trying to pull those name-value JSON pairs from a text file or log file to put into a spreadsheet, you don’t need to write some Python script do this. And hopefully you ARE thinking twice about putting your company’s data into one of those free services on the Internet.

No comments:

Post a Comment