Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- let
- Source = Json.Document(Web.Contents("https://jsonplaceholder.typicode.com/posts")),
- #"Converted to Table" = Table.FromList(Source, Splitter.SplitByNothing(), null, null, ExtraValues.Error),
- #"Expanded Column1" = Table.ExpandRecordColumn(#"Converted to Table", "Column1", {"userId", "id", "title", "body"}, {"userId", "id", "title", "body"})
- in
- #"Expanded Column1"
- <connection id="1" keepAlive="1" name="Query - posts" description="Connection to the 'posts' query in the workbook." type="5" refreshedVersion="6" background="1" saveData="1">
- <dbPr connection="Provider=Microsoft.Mashup.OleDb.1;Data Source=$Workbook$;Location=posts;Extended Properties=""" command="SELECT * FROM [posts]"/>
- </connection>
Add Comment
Please, Sign In to add comment