topic Are you using Workato + PowerBi in Workato Pros Discussion Board

Are you using Workato + PowerBi

femi-ariyo — Wed, 10 Feb 2021 07:18:19 GMT

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?

Re: Are you using Workato + PowerBi

mroldanvega — Thu, 11 Feb 2021 06:26:05 GMT

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.

Re: Are you using Workato + PowerBi

femi-ariyo — Thu, 11 Feb 2021 07:36:51 GMT

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

Re: Are you using Workato + PowerBi

mroldanvega — Fri, 12 Feb 2021 07:25:08 GMT

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.

Re: Are you using Workato + PowerBi

femi-ariyo — Fri, 12 Feb 2021 22:56:50 GMT

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.