protection office 365 data source

[egmarcote]

Hello
We have hired the office 365 protection service. I would like to know if there is a data source to be able to make the connection from power bi and make a customized dashboard.
Is there any way to do it?
Regards, and thank you so much

[v-yuezhe-msft]

@egmarcote,

Please check if the PBIT file in the following blog is helpful in your scenario.

https://blogs.technet.microsoft.com/educloud/2017/06/15/exchange-online-mail-protection-power-bi-rep...

Regards,
Lydia

[egmarcote]

Hello @v-yuezhe-msft

I have followed the indicated steps but it generates an error when updating

Thank you

[v-yuezhe-msft]

@egmarcote,

What is the full name of your Office protection service?

Regards,
Lydia

[egmarcote]

Hello @v-yuezhe-msft,
Where could I consult it?
I am working through the Security & Compliance application and I would like to be able to make a picture in power bi with this data

Regards

[v-yuezhe-msft]

@egmarcote,

Please take a look at the following blogs about how to use  Office 365 Management Activity API for security analysis.

https://techcommunity.microsoft.com/t5/Security-Privacy-and-Compliance/Using-the-Office-365-Manageme...

https://techcommunity.microsoft.com/t5/Security-Privacy-and-Compliance/Using-the-Office-365-Manageme...

Regards,
Lydia

[egmarcote]

Hello @v-yuezhe-msft:

I found the following data source:

https://msdn.microsoft.com/EN-US/library/office/jj984347.aspx

I am reviewing the tables, in many cases I have already managed to obtain the same graphics as those shown in protection office. It would be nice if the protection office website could consult the query made by the reports

Regards

[v-yuezhe-msft]

---

---

It would be nice if the protection office website could consult the query made by the reports

@egmarcote,

You can post question in the Office 365 forums to get better support. Power BI Desktop will return the result that office 365 API provides.

Regards,
Lydia