Create/Export Office 365 Security & Compliance reports in PowerBI RRS feed

  • Question

  • I see the below dashboard in office 365 reports section which I want it to show it in PowerBI. Is there any way by which I can export these to PowerBI with scheduled refresh data.

    In addition to this, I also want AdvancedThreatProtectionTraffic report in PowerBI.

    Need MailTraffic, MailSpam etc reports.

    I have found a blog which does similar (, but i get some error which generating AdvancedThreatProtectionTraffic report. I tried generating the same in excel, still error. The reporting web service throws error. (

    Is there any other way to get these reports in PowerBI ?


    Monday, November 11, 2019 5:43 AM