Power BI · FraudShield

Overview

Embedded Report

Connect Power BI

Data Endpoints

—

Total Transactions

—

Fraud Detected

—

Fraud Rate

—

Total Amount

Fraud by Transaction Type

Risk Distribution

Amount Distribution (Top Fraud)

GNN Probability Scatter

Hourly Trend

Recent High-Risk Transactions

TX ID	Source	Dest	Amount	Type	GNN Score	Risk

Power BI Embedded Report

📊

No Embedded Report Configured

Set the following environment variables to embed a published Power BI report:

POWERBI_EMBED_URL POWERBI_REPORT_ID POWERBI_ACCESS_TOKEN

Connect Power BI Desktop

Open Power BI Desktop

Click Get Data → Web to add a REST API data source.

Enter the Data Endpoint URL

Use one of the endpoints below, e.g.
http://localhost:8081/api/powerbi/transactions

Transform & Load

Power BI will parse the JSON array. Use Power Query Editor to expand columns, set data types (Amount → Decimal, Timestamp → DateTime).

Build Visuals

Recommended visuals: Matrix (risk × type), Scatter (src_prob vs dst_prob, size=amount), Line chart (fraud trend by step), Card (total fraud count & rate).

Schedule Refresh

Publish to Power BI Service and configure a Scheduled Refresh using a data gateway for automatic updates.

Power Query M Template

let
    Source = Json.Document(
        Web.Contents("http://localhost:8081/api/powerbi/transactions")
    ),
    ToTable = Table.FromList(Source, Splitter.SplitByNothing(), null, null, ExtraValues.Error),
    Expanded = Table.ExpandRecordColumn(ToTable, "Column1",
        {"tx_id","timestamp","step","source","destination","amount",
         "type","src_fraud_prob","dst_fraud_prob","risk_level",
         "is_fraud_predicted","label"}),
    TypedCols = Table.TransformColumnTypes(Expanded, {
        {"amount", type number},
        {"src_fraud_prob", type number},
        {"dst_fraud_prob", type number},
        {"step", Int64.Type},
        {"is_fraud_predicted", type logical},
        {"label", Int64.Type}
    })
in
    TypedCols

Available REST API Endpoints

GET/api/powerbi/transactionsAll transactions (flat table, PBI-ready)

GET/api/powerbi/summaryAggregated stats by type & risk level

GET/api/powerbi/timeseriesTime series data by step

GET/api/powerbi/fraud_nodesHigh-risk accounts & GNN scores

Live API Response Preview