Forum Discussion
Microsoft Graph Security - Only returning 20 rows
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
1 Reply
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
