Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
14 | |
2 | |
2 | |
1 | |
1 |