Add Orchidea as a data source to Microsoft Power BI

You can add Orchidea as a data source to Microsoft Power BI with a few simple clicks

Needed plan

This feature is available on Orchidea Professional and Enterprise plans.

Notice!

You need to be a workspace admin or owner to modify the settings.

Here is how you add Orchidea as a data source to Microsoft Power BI:

1. Click your user avatar icon in the top-right corner and select Workspace Settings from the menu. Then select Integrations in the left menu. Click the Power BI tab.

   

2. Click Generate new secret key and select the user whose access rights the integration will reflect. The integration can always read data from all public channels, challenges, and workshops in the workspace. Access to private channels, challenges, and workshops will be granted to those channels, challenges, and workshops where the selected user is a member.

   1. Once you have selected the user, click Submit.

   

3. Copy the Secret key that you just created.

   

4. Open Microsoft Power BI Desktop on your PC.

5. Click Get data in the ribbon and select Web.

   

6. Click Advanced in the appearing window.

   

7. Form the URL part that defines the data.

   1. It starts with the common URL https://app.orchidea.dev/api/bi/proposals?
   2. You must include the from query parameter. It tells the API: "Give me proposals updated or deleted since this date."
      1. For example: https://app.orchidea.dev/api/bi/proposals?from=2025-01-01
      2. Give the date in the format YYYY-MM-DD for example 2025-01-01.
   3. Define the data fields you want to include by adding them after the date. The data field part starts with &include= and the data fields are separated with the + sign.
      1. For example, proposal title and status: https://app.orchidea.dev/api/bi/proposals?from=2025-01-01&include=title+status
      2. Available data field values are:
         1. title
         2. createdAt
         3. viewCount
         4. commentCount
         5. channelName
         6. link
         7. status
         8. hashtags
         9. creators
         10. handlers
         11. statusHistory
         12. reactions
         13. classification

8. Fill in the URL you formed above in the URL parts field in the window.

   

9. Copy the text X-API-Key to the left field in HTTP request header parameters.

   

10. Copy the Secret key that you created in step 3 of this article to the right field in HTTP request header parameters.

    

11. Click OK to add Orchidea as a data source to Microsoft Power BI.

    If you receive an error message after clicking OK, decrease the data set size by selecting a date closer to today in the from query parameter in step 7.