Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedJoin us at the 2025 Microsoft Fabric Community Conference. March 31 - April 2, Las Vegas, Nevada. Use code FABINSIDER for $400 discount. Register now
@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 want to know the refresh history of each dataset. The request URL is following
https://api.powerbi.com/v1.0/myorg/datasets/{datasetId}/refreshes
Is it doable? How do I make adjustments to the following to get the refresh history forEach dataset
WITH cte_workspaces AS (
SELECT explode(pbi_api_udf('/groups', '${pbi_access_token}')) as workspace
)
SELECT workspace.name, workspace.id, pbi_api_udf(concat(workspace.apiPath, '/datasets'), '${pbi_access_token}') as datasets
FROM cte_workspaces
Solved! Go to Solution.
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
Hi @smpa01
Glad that your query got resolved. Please continue using Fabric Community for any help regarding your queries.
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
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Check out the February 2025 Fabric update to learn about new features.
User | Count |
---|---|
29 | |
3 | |
3 | |
2 | |
2 |
User | Count |
---|---|
12 | |
8 | |
7 | |
5 | |
4 |