Qooling API to PowerBI

Modified on Fri, 13 Mar at 3:29 PM

1. Create a new empty query: Open Power BI Desktop, go to "Get Data," and select "Blank Query."

2. Select the "Advanced Editor" option: This is located in the Home tab of the Power Query Editor ribbon.

3. Enter the following code:

Code snippet
let
    apiUrl = "https://app.qooling.com/rest/v2/issues",
    options = [Headers =[#"Authorization" = "Bearer {Token}"]],
    result = Web.Contents(apiUrl , options)
in
    result

Note: Use your actual token here by replacing {Token} with your specific credentials. Once entered, the data will be loaded.

4. Double-click on the JSON object: It will likely appear as app.qooling.com.

5. Convert to Table: You will see a list. Double-click on the column header titled "List" and then select the "To Table" option from the menu.

6. Expand the data: You can now expand the table to your desired format by clicking the expand icon (two small arrows pointing outwards) in the top-right corner of the column header.

7. Success: Your data is now loaded into Power BI!