Forum Discussion
cisco
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?
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
1 Reply
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