Connecting to AI Workspaces with Power BI

Connection Script

Since PowerQuery doesn't provide an interface that lets you configure an authentication step, you'll need to setup an authentication script in PowerQuery. To do this, from PowerBI Desktop go to Transform Data > Advanced Editor and enter the script below. When finished select 'Close and Apply'. Power BI may prompt for authentication, choose Anonymous as the script handles authentication for you. Anytime you select Refresh, PowerBI will generate a new token and update the display.

// Step 1: Retrieve Bearer Token
let AuthUrl = "https://auth.qoreai.com/realms/bocore/protocol/openid-connect/token",
    AuthBody = [
        client_id = "bocore-app",
        username = "your-username",
        password = "your-password",
        grant_type = "password"
    ],
   
    AuthResponse = Json.Document(Web.Contents(AuthUrl, [
        Content = Text.ToBinary(Uri.BuildQueryString(AuthBody)),
        Headers = [
            #"Content-Type" = "application/x-www-form-urlencoded"
        ],
        ManualStatusHandling = {400}
    ])),

    AccessToken = AuthResponse[access_token],  // Extract token

    // Step 2: Call Data API using the Bearer Token
    ApiUrl = "https://app.qoreai.com/api/v1/app/ai/workspace/export/json",
    ApiBody = "{""workspaceId"": 12345, ""filter"": []}", // Adjust workspaceId and filter as needed
 
    DataResponse = Web.Contents(ApiUrl, [
        Content = Text.ToBinary(ApiBody),
        Headers = [
            #"Authorization" = "Bearer " & AccessToken,
            #"Content-Type" = "application/json"
        ]
    ]),

    JsonData = Json.Document(DataResponse)  
in JsonData