Custom REST calls

gbrueckl came across this fantastic piece . I have tested it out and it is simply awesome. I was wondering if there is a way to utilize any of the RESTApi calls here. For example, what if I w...

data engineering

gbrueckl

2 years ago

something like this should technically work

WITH cte_workspaces AS (
    SELECT explode(pbi_api_udf('https://api.powerbi.com/v1.0/myorg/groups', '${token}')) AS workspace
),
cte_datasets AS (
SELECT workspace.name AS ws_name, workspace.id AS ws_id, explode(pbi_api_udf(concat(workspace.apiPath, '/datasets'), '${token}')) AS dataset
FROM cte_workspaces
)
SELECT ws_name, ws_id, dataset.name AS ds_name, dataset.id AS ds_id,
    explode(pbi_api_udf(concat(dataset.apiPath, '/refreshes'), '${token}')) AS refreshes
FROM cte_datasets

but I just tried it on my quite small environment and it errors out with too many requests

Forum Discussion

Custom REST calls

Related content

Rest API Informations

Rest api call with multiple pages

Permissions issue while calling a Rest API

Error when calling Notebook from Rest API

Create a fabric deployment pipeline using rest API call