cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
dluzzi Frequent Visitor
Frequent Visitor

MS Graph results limited to 30 days

Hello,

 

I am trying to call MS Graph from powerbi using the custom connector posted in github.

 

I have a filter in place so its only downloading the relative information however it only shows 30 days worth.  Is there a limit on results when there is a filter in place?

 

 

2 REPLIES 2
Moderator v-yuezhe-msft
Moderator

Re: MS Graph results limited to 30 days

@dluzzi,

What filter do you place? Do you get expected amount of data before adding a filter? Could you please share the Power Query code you used?

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
dluzzi Frequent Visitor
Frequent Visitor

Re: MS Graph results limited to 30 days

Hello the filter was https://graph.microsoft.com/beta/auditLogs/signIns?$filter=startswith(appDisplayName('PRAM-')&$expan...

 

Running the query with just auditLogs/signIns takes a long time to complete and never seems to finish powerBI just keeps downloading then restarts and keeps downloading.  I wonder if its a paging issue or not.  I am using the MyGraph connector sample from github: https://github.com/Microsoft/DataConnectors/tree/master/samples/MyGraph