Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
jude_moore
Helper II
Helper II

Email counts from office 365

Hi PowerBI'ers

 

We would like to bring back email counts, sent , received, read, for all users per day from Azure / Microsoft Graph / Outlook API / Office 365 ?

 

We would like to bring back meetings / events for all users per day from Azure / Microsoft Graph / Outlook API / Office 365 ?

 

For the last three months would be handier than just the last month.

 

I have used GET https://reports.office.com/pbi/v1.0/  but no avail since these are aggregated for the whole of last monthy always ands not split by day.

 

Also tested was GET https://graph.microsoft.com/v1.0/  , but I cannot retreive all users events as the API rejects making seperate calls for each user for this volume, and I not sure how to make $batch requests iwith the MS Graph API for the 264 users I want to query.

 

Also if anyone knows how to use this in Power Bi very useful . Many thanks :

POST https://outlook.office.com/api/{version}/me/findmeetingtimes 

 

Regards

 

Jude

 

 

0 REPLIES 0

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Fabric Monthly Update - May 2024

Check out the May 2024 Fabric update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.