Forum Discussion
Azure AD API signInevents
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?
3 Replies
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
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/?trackingId=tVNWLTT0IijQqeR8p9%2FyRg%3D%3D
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
