cisco

[Anonymous]

Has anyone tried to create Power BI reports from data in a Cisco email security appliance. If so, how were you able to do that?

[v-yuezhe-msft · Accepted solution]

@Anonymous,

Based on my research, AsyncOS API provides secure and authenticated access to the Email Security appliance reports and report counters. You can connect to this API in Power BI Desktop to retrieve the Email Security appliance reporting data.

You can add a  new blank query in Power BI Desktop, and paste the following code in Advanced Editor. 

let
    Source = Json.Document(Web.Contents("YourURL", [Headers=[Authorization="Basic <Base64-encoded credential>", ContentType="application/json"]]))
in
    Source

Regards,
Lydia