Power BI
Acho supports connecting to Power BI via API. The process to export data to Power BI includes two steps:
  1. 1.
    ​Generate API for your table (each table will generate a unique API)

Step 1: Generate API for your table

1. Click the export button on the top right of the table.
​
2. Select Power BI and click Generate API.
3. When the API is generated successfully, a green message will pop up from the top of the page. The Power BI connector API will be copied to your clickboard automatically

Step 2: Export data to Power BI

1. Open your Power BI and navigate to Get Data > Web.
3. Paste the API that you just generated in the input field and click Enter.
3. Once your Power BI connects to Acho successfully, a preview window shows up. Click the Load button to continue.
4. It may take a few seconds to retrieve data depending on your table size. When your data is ready, it will appear in the Fields.
5. If your table on Acho is changed or updated, you can click the dropdown next to the table name and choose Refresh data to retrieve data again.
Last modified 1mo ago