---
title: PowerBI Integration
description: "Microsoft Power BI integration lets you turn iX ERP data into interactive reports and dashboards. Connect through API4 using your API key, choose the data you need, and configure refreshes to keep reports up to date. ``` let url =…"
url: "https://wiki.ixerp.net/wiki/powerbi-integration/"
updated: "2026-10-13"
category: iX ERP Integration
---

# PowerBI Integration

Microsoft Power BI integration lets you turn iX ERP data into interactive reports and dashboards. Connect through API4 using your API key, choose the data you need, and configure refreshes to keep reports up to date.

```
let
    url = Text.TrimEnd(URL, "/") & "/query",
    body = Json.FromValue([
        operation = "profit_loss_trans",
        parameters = [
            from_date = "01/01/20??",
            to_date = "01/01/20??"
        ]
    ]),
    head = [
        #"Content-Type" = "application/json",
        #"X-API-KEY" = ApiKey
    ],
    Source = Json.Document(
        Web.Contents(url, [Headers = head, Content = body])
    ),
```