topic Re: Azure Resource Graph Explorer API connection in Developer

Azure Resource Graph Explorer API connection

vcb_001 — Thu, 31 Aug 2023 13:38:36 GMT

Hi,

my manager wanted me to work on a solution to provide continuously refreshed data source for our dashboard where we normally use an excel workbook to retrieve the data.

The problem is that we use Azure Resource Graph query to export the exact data source but, there is no possible way of constructing a Power BI connection with this technology at the moment.

Therefore, I would like to ask you that anyone has handled this kind of issue so far? like creating an API to retrieve the data from this query continuously or something like that. Is it possible? If so, could you please guide me to enable this connection?

I greatly appreciate any feedback or comment from your side!

Thanks.

Re: Azure Resource Graph Explorer API connection

lbendlin — Tue, 05 Sep 2023 00:06:39 GMT

I recommend you look into (hybrid) streaming datasets. You can push rows into these from a variety of tools, including batch scripts, PowerShell, or Power Automate. You can make it as close to real time as you want.

Re: Azure Resource Graph Explorer API connection

vcb_001 — Tue, 05 Sep 2023 07:23:38 GMT

Thank you for the recommendation, I need a starting point for looking into those ways. Could you please let me know where I should start from? Maybe a link, a resource would be helpful.

Re: Azure Resource Graph Explorer API connection

lbendlin — Tue, 05 Sep 2023 14:16:35 GMT

Real-time streaming in Power BI - Power BI | Microsoft Learn