From the course: Power BI Data Methods

Unlock the full course today

Join today to access over 23,200 courses taught by industry experts.

Connecting to JSON data

Connecting to JSON data - Power BI Tutorial

From the course: Power BI Data Methods

Start my 1-month free trial Buy for my team

Connecting to JSON data

“

- [Instructor] JSON files are a common format for storing data, especially for computer generated data sources. JSON data can be tricky for humans to read, but easy for computers to parse. Let's walk through an example of how to connect to a JSON file storing NOAA H weather results for Santa Barbara for January 1st and second of the year 2024. The first thing we notice about JSON files is the general structure of the file. To look at levels of elements, we want to look at their levels of indentation. When their level of indentation matches up, they're on the same layer of the data when we drill into it. JSON data might not necessarily appear by default with this nice indentation, but if you would like to display it in this way, I encourage you to check out tools that do enable you to format JSON data nicely like this. It's important to note that records in JSON data appear in curly braces while lists appear in square brackets. Power query object syntax doesn't match that of the JSON…

Contents