Power bi integration

[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…