Forum Discussion

BroomJ's avatar
BroomJ
Frequent Visitor
8 years ago

Connecting to Microsoft Graph API to report on Email Activity, Do I need an authentication token?

Hello,   At the very core, I'm essentially aiming to recreate the Office 365 Admin Center Email Activity report that shows the number of Send, Receive and Read actions on emails for each user withi...
Need Help
BroomJ's avatar
BroomJ
Frequent Visitor
8 years ago

Apologies for the delay, I have been rather busy and only just managed to pick this back up.

 

Upon further research, I managed to find the following article:

 

https://github.com/Microsoft/DataConnectors/blob/master/samples/MyGraph/README.md

 

Following this has allowed me to create a custom connector but upon testing, I can only get it to return a byte array rather than the actual data in a usable format.

 

I'm using the power query code on that page, but I think it's missing some steps to use the next link and download URL redirect correctly.

 

Unfortunately, my power query knowledge isn't the greatest so I'm not sure how to get around these two issues.

 

Here is what Visual Studio returns if I run the query:

 

 

Would it be wiser for me to move this over to the Developer forum rather than the Desktop one?

Anonymous's avatar
Anonymous
Not applicable
8 years ago

BroomJ,


Yes, it is more appropriate that you post the question in Power BI Developer forum when you create custom connectors.

Regards,
Lydia