Forum Discussion

kyleuk's avatar
kyleuk
New Member
7 years ago

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 of...
Need Help
TeigeGao's avatar
TeigeGao
Solution Sage
7 years ago

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