Microsoft Graph Security - Only returning 20 rows

[kyleuk]

Hi

Currently testing the new graph security data source in PowerBI desktop after the latest update.

Run into an issue whereby I can only see 20 rows from the 'Alerts' table. I've followed the official steps, using an account with the right permissions and tried with both v1.0 and beta versions.

What I haven't looked at yet is a custom query as I'm not familiar with the URLs I would need to query, but if anyone can point me in the right direction I would be grateful:

Anyone have any ideas?

Kind Regards

Kyle

[TeigeGao]

Hi kyleuk,

Could you please try to use the OData feed connector connecting to “ https://graph.microsoft.com/ ” and have a test? Please refer to this blog: https://prathy.com/2017/11/access-microsoft-graph-api-using-power-bi/

The “Specify custom Microsoft Graph Security URL to filter results” function will let you set a filter on the connection link, for example: https://graph.microsoft.com/v1.0/security/alerts?$filter=Severity eq 'High' will returns the data from alert where Severity equals High.

Best Regards,

Teige