Skip to content

Instantly share code, notes, and snippets.

@StuffbyYuki
Created November 9, 2021 20:30
Show Gist options
  • Save StuffbyYuki/fbeb4bb8ca0e3bf5c8bdb04192c6e8fd to your computer and use it in GitHub Desktop.
Save StuffbyYuki/fbeb4bb8ca0e3bf5c8bdb04192c6e8fd to your computer and use it in GitHub Desktop.
Power Query - Get datasets in a workspace through PBI REST API
(group as text, token as text) =>
let
Source = Json.Document(Web.Contents("https://api.powerbi.com/v1.0/myorg/",
[
RelativePath = "/groups/" & group & "/datasets",
Headers=[Authorization="Bearer " & token]
]
)),
value = Source[value]
in
value
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment