Forum Discussion
How to refresh Datasets with PowerBI REST API - executed in Azure Data Factory Pipeline
Hi, I've built multiple pipelines in Azure data factory and a few Power BI reports (https://app.powerbi.com) that use data from those pipelines. My ultimate goal is to be able to refresh a Power ...
Gonna try this solution. Magic search word = Postman
yaay, some small progress
another step forward, not sure how i get this token into a new API post
gonna try creating a powershell script and run that script in ADF using a webhook,
special thanks to https://blog.gbrueckl.at/2017/08/refresh-powerbi-datasets-powershell-azure-runbooks/
https://stackoverflow.com/questions/52697381/power-bi-dataset-refresh-using-powershell
- Used the following as Powershell script, and it worked :cathappy:$body = @{"client_id" = "bf..........";"grant_type" = "password";"username" = ".......@.........";"password" = ".............";"scope" = "openid"}$authResponse = Invoke-RestMethod -Uri $authUrl –Method POST -Body $body$headers = @{"Content-Type" = "application/json";"Authorization" = $authResponse.token_type + " " +$authResponse.access_token}$restResponse = Invoke-RestMethod -Uri $restURL –Method GET -Headers $headers$datasetId = "ab5d......."$groupId = "ecb5......"$body = @{"notifyOption"= "MailOnFailure"}$restResponse = Invoke-RestMethod -Uri $restUrl –Method POST -Headers $headers -Body $body