Azure AD API signInevents

[Jmcgrath]

Has anyone had success refreshing Azure AD Activity API data in Power Bi service

for this endpoint.  https://graph.windows.net/<my domain>.com/activities/signinEvents?api-version=beta

I run into power bi service not able to refresh functions.

how to overcome not using functions to work around 1000 row batch limit?

then when I don't use a function just return first 1000 rows says my credential in service are invalid.

All works perfect in desktop application.  Any ideas?

[Anonymous]

Check out this post related to the Graph API. https://www.linkedin.com/pulse/loading-data-paged-related-from-ms-graph-api-power-bi-rob-reilly/?tra...

[Jmcgrath]

Thanks for suggestion.  I implemented this as well , doesn't refresh in the Power Bi service works great in power bi desktop though.

I believe the reason is power query functions not supported in power bi service refresh.  I have support ticket in anwer this question.

Thanks

[Jmcgrath]

Going to access API through Powershell script executed in a scheduled runbook writing to database that power BI read.  It appears API refresh and Power Bi service don't work well together so trying alternate solution