Azure resource graph explorer

Hi GRob 

Currently there is no direct connector in Power BI to Azure Resource Graph. You may query the data first, export the returned data and then use them in Power BI.

Here is an idea about this requirement you can vote for:

https://feedback.azure.com/forums/915958-azure-governance/suggestions/36072472-visualize-resource-graph-in-powerbi

Regards,
Community Support Team _ Jing

Using continuous export to Log Analytics workspace for Security recommendations.

When running query on Log Analytics workspace for recommendation (Endpoint protection should be installed on your machines), the count of (unhealthy , healthy , not applicable) , does not match when comparing it to query using Azure Resource Graph Explorer. It seems Log Analytics workspace does not pick up older records (prior to me enabling continuous export to Log Analytics workspace).
I do get the correct fields (RecommendationDisplayName, RecommendationName, RecommendationState, Description, RemediationDescription).

.................................

// *** Azure Resource Graph Explorer query is below:
securityresources
| where type == "microsoft.security/assessments"
| where displayName == "Endpoint protection should be installed on your machines"

// statusChangeDate: from 2021-08-02 to 2021-11-03

.................................

// *** Log Analytics workspace (LAW) query is below:
SecurityRecommendation
| where RecommendationDisplayName == "Endpoint protection should be installed on your machines"

// statusChangeDate: 11/1/2021

..............................................................................................................................................................................................................

Using continuous export to Event Hub for Security recommendations. Ingested the data into Azure Data Explorer.

I don't get the required fields (RecommendationDisplayName, RecommendationName, RecommendationState, Description, RemediationDescription).

Instead I get these fields (operationName, level, resultType, category, properties, durationMS, callerIpAddress, identity, jobId, jobType, x-opt-enqueued-time)

// *** DATAEXPLORER query is below:
Assessments
| where ['x-opt-enqueued-time'] > ago(1d)
| take 5000

..............................................................................................................................................................................................................

Summary:
Azure Resource Graph Explorer gives me accurate count of records in (Microsoft Defender for Cloud, Recommendations, All recommendations).
Using continuous export to Log Analytics workspace for Security recommendations gives correct fields, but incorrect count of records.
Using continuous export to Event Hub for Security recommendations gives incorrect fields.

What other method/s can I use that will work for me ?

Is it possible for Microsoft to add 'Export to Power BI (M query)' to Azure Resource Graph Explorer ? 

I found the below repo. I couldn't locate further documentation though.

viktorradu/powerbi-azure-resource-graph-connector (github.com)