Power bi integration

[uzair94]

Can we automatically integrate manager with microsoft power bi?

[Ealfardan]

You can find your solution here:

API using excel

Just wanted to share this updated Power Query connector function for Excel and Power BI. let _getObjectIndex = (url as text, optional business as text, optional object as text) => let objectURL = url & (if business <> null then "/" & business else "") & (if object <> null then "/" & object else "") & ".json", result = try Json.Document(Web.Contents(objectURL)) otherwise null in result, _getObjectTab…

[Danny_Ho]

Can I use it on data studio?

[Ealfardan]

Hi @Danny_Ho, welcome to the forum.

No. It has to be rewritten in JavaScript.