cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Jmcgrath Regular Visitor
Regular Visitor

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 3
Jmcgrath Regular Visitor
Regular Visitor

Re: Azure AD API signInevents

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

Re: Azure AD API signInevents

Jmcgrath Regular Visitor
Regular Visitor

Re: Azure AD API signInevents

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