Skip to content

Instantly share code, notes, and snippets.

@ninmonkey

ninmonkey/Using JSON from a web api in PowerBI.pq

Created June 5, 2020 00:21
Show Gist options
  • Save ninmonkey/0a35f2d8314c40a65124fb89166e015b to your computer and use it in GitHub Desktop.
Save ninmonkey/0a35f2d8314c40a65124fb89166e015b to your computer and use it in GitHub Desktop.
Download ZIP
Using JSON from a web api in PowerBI.pq
Raw
Using JSON from a web api in PowerBI.pq
let
// basic json ( non-authenticated get request )
Source_Json = Json.Document(Web.Contents("https://api.publicapis.org/random")),
Source_Table = Record.ToTable(Source_Json),
Entries = Source_Table{ [Name="entries"] }[Value],
result=Entries
in
result
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment