I'm trying to push data to a PowerBI online dataset, to automatically update financial dashboards for our company.
Here's where we stand:
- We have PowerBI pro accounts with a few dashboards, reports and datasets published internally.
- We have an Azure account and the possiblity to create whatever we need in there
After reading a whole lot of (sometimes contradictory) documentation, here's what I think I want:
- setup a cron job to update datasets nightly
- use the PowerBI Rest API to update the datasets that were published by the analysts
- use a service principal to authenticate against that API
- ideally, use the C# (or typescript?) library to interact with the API, although not strictly necessary
Here's, in no particular order, some of the doc pages I've been through:
- https://docs.microsoft.com/en-us/power-bi/developer/automation/walkthrough-push-data
- https://powerbi.microsoft.com/nl-be/blog/use-power-bi-api-with-service-principal-preview/
- https://github.com/Microsoft/PowerBI-CSharp#usage-calling-the-getreports-api
- and so many others I've lost track of.
I'm not familiar with Azure, so I may be missing key background knowledge, but I can't, for the life of me, figure out how to setup and use this api with a service principal...
...
Please send help!
