Azure Resource Graph Explorer API connection

[vcb_001]

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.

[lbendlin]

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.

[vcb_001]

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.

[lbendlin]

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