March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
Register NowGet certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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 BI data set at the end of a pipeline. Underneath I'll show a small selection of what i've read and tried so far.
https://medium.com/@Konstantinos_Ioannou/refresh-powerbi-dataset-with-microsoft-flow-73836c727c33
https://mitra.computa.asia/articles/msdn-how-use-power-bi-embedded-rest
I started by registrating at https://dev.powerbi.com/apps and with API Acces "Select All". I checked in the azure portal the app registrations. I registrated twice because i was not sure if the oauth20 (following @konstantinos) would screw thing up:
Then I started in Azure data factory, but after a while (of having failures) I started using Fiddler to send the HTTP Post request.
I use the logic described at https://docs.microsoft.com/en-us/rest/api/power-bi/datasets/refreshdatasetingroup. It says:
"POST https://api.powerbi.com/v1.0/myorg/groups/{groupId}/datasets/{datasetKey}/refreshes"
I get my group and dataset ID at https://app.powerbi.com/....
I copy this link into Fiddler:
My best guess would be that i should include authentication into the request body, although i cant find examples online.
Eventually I want to refresh the dataset from a 'web' container in ADF. Although, lets start succesfully refreshing something first 🙂
Gonna try this solution. Magic search word = Postman
yaay, some small progress
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
Thanks for the help Robinator!
You're welcome
another step forward, not sure how i get this token into a new API post
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
Check out the November 2024 Power BI update to learn about new features.
User | Count |
---|---|
17 | |
4 | |
4 | |
3 | |
3 |