I had a need this week and I solved it by using Workato to push data into a cloud DB that the user was able to point PowerBI and consume data. I came across a PowerBI integration page on Workato.com - it made me wonder if and how top chefs out there may be using Workato + PowerBI. Is it oData or similar type of data stream?
We used the SDK to build a custom connector using the Microsoft Office Management API to extract PowerBi activity logs.
It is farily straightforward, with th exception of parsing the logs.
We have several use cases where the MS Graph API and Office Management API have come in very handy with the SDK.
Here's the link to the connector - https://app.workato.com/custom_adapters/24315/details?token=52b7df99
and here's the recipe:
Let me know if you have any questions.