PowerBI Integration with iX ERP is done through connection to iX ERP API as per the steps below.
Using Microsoft PowerBi Desktop (Free for Download here)From the “Get Data” menu choose “Blank Query”.
From the “Blank Query” windows choose “Advanced Editor”, in the advanced editor write the API connection as follow”
let
url = "https://applicationdomain.io/modules/api3/API_Function_Address",
body = "{""Filter1"":""xxxxxx"", ""Filter2"":""xxxxxx"", ""Filter3"":""xxxxxx"", ""Filter4"":""xxxxxx""}",
head = [#"Content-Type"="application/json",#"X-COMPANY"="Company_Number", #"X-USER"="API_Username", #"X-PASSWORD"="API_Password"],
Source = Json.Document(Web.Contents(url, [Headers=head, Content = Text.ToBinary(body)]))
in
#"Source"
