Are you using Workato + PowerBi

[femi-ariyo]

Hello Chefs,

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?

[mroldanvega]

Hi,

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.

[femi-ariyo]

Thanks Manuel. Please if you have some time, can you share the recipe/sanitized version of course. Thank you.

[mroldanvega]

Here's the link to the connector - https://app.workato.com/custom_adapters/24315/details?token=52b7df99

and here's the recipe:

https://app.workato.com/recipes/1304775?st=590288

Let me know if you have any questions.

[femi-ariyo]

Thanks once again. I was able to trace the code fairly well. I can certainly resuse your custom Office API and a few other pieces of the logic. Greately appreciate.