Blog Archives

Loading JSON … it looks simple … Part 4

This is part 4 and the final post of this JSON series. We are going to play with Smartsheet data because its adds to our examples of varying JSON structure. Note that Power BI already has a connector for Smartsheet.

Tagged with: , ,
Posted in Power BI, Python, Python4PowerBI

Loading JSON … it looks simple … Part 3

This is part 3 of the introduction to handling JSON with Python. This post covers a real world example that accesses data from public API from the New York City Open Data. For fun we are going to look at

Tagged with: , , ,
Posted in Power BI, Python, Python4PowerBI

Loading JSON … it looks simple … Part 2

The previous post might have left you feeling that its a bit too complicated and a bit too abstract. Dont worry, the concepts will be clearer after a bit of a visual recap and then exploring how we would navigate

Tagged with: , , ,
Posted in Power BI, Python, Python4PowerBI