Add Orchidea as a data source to Microsoft Power BI

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

1. Click Workspace settings in your user profile menu. Then select Integrations in the left navigation. Click Power BI tab.

1. 1. 
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 selected the user, click Submit.
   2. 
3. Copy the Secret key that you just created.
   1. 

4. Open Microsoft Power BI Desktop on your PC

5. Click Get data in the ribbon and select Web
   
   1. 
6. Click Advanced in the appearing window
   1. 
7. Form the URL part that defines the data
   1. Is starts with the common 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 format YYYY-MM-DD (example: 2025-01-01)
   3. Define the data fields that you want to include in the data by adding them after the date. Data field part start with "&"-sign, and the data fields are separated with "+"-sign. 
      1. For example proposal title and status: https://app.orchidea.dev/api/bi/proposals?from=2025-01-01&title+status
      2. 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 above formed URL to URL parts field in the window
   1. 
9. Copy text X-API-Key to the left field in HTTP request header parameters (optional)
   1. 
10. Copy the Secret key that you created in step 3 of this article to the right field in HTTP request header parameters (optional)
    1. 
11. Click OK to add Orchidea as a data source to Microsoft Power BI.
    1. 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.b of this article.