Has anyone connected to a GlideTable using PowerBI directly via Power Query and the GlideAPI?
I believe you need to write a Power Query and start from a blank query since the Glide API is all POST requests.
I am just struggling with the format as I am new to PowerBI but I figure someone has already done this somewhere.
This is my PowerQuery code, XXX replace my app info:
let
url = "https://api.glideapp.io/api/function/queryTables",
header=[#"Content-Type"="application/json", #"Authorization"="Bearer XXX"],
body = [appID = "XXX", queries = {[tableName = "native-table-XXX", utc = "true"]}],
response = Web.Contents(
url,
[
Headers = header,
Content = Json.FromValue(body)
]
),
jsonResponse = Json.Document(response)
in
jsonResponse
Has anyone else had any luck with this? I get an Error 400 with this query above.