This time we’re going bigger than ever. Fabric, Power BI, SQL, AI and more. We're covering it all. You won't want to miss it.
Learn moreDid you hear? There's a new SQL AI Developer certification (DP-800). Start preparing now and be one of the first to get certified. Register now
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?
Solved! Go to 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
@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
Check out the April 2026 Power BI update to learn about new features.
Sign up to receive a private message when registration opens and key events begin.
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.