> For the complete documentation index, see [llms.txt](https://docs.skyone.cloud/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.skyone.cloud/english/skyone-studio/how-to/how-to-create-a-download-endpoint-and-integrate-with-power-bi.md).

# How to create a download endpoint and integrate with Power BI

### Context

Imagine you've processed data in a table using **Skyone Studio** and want to export it to Power BI to create a dashboard.&#x20;

In this documentation, we will detail step-by-step how to use the "[File Template](https://docs.skyone.cloud/english/skyone-studio/data-management/file-templates.md)" feature and how to integrate it with Power BI.

### Step by step

1. In **Data Studio**, navigate to the directory that contains the data and click on **"File Templates**".
2. Next, click on "**New template**".
3. Fill in the required fields. [You can read more details here](https://docs.skyone.cloud/english/skyone-studio/data-management/file-templates.md#add-template). For our example, we used the following setup:
   * **Template Name**: processedbenefits
   * **Type**: CSV
   * **Directory**: /uploads
   * **File Name**: processedbenefits
   * **Read Groups**: default
   * **Write Groups**: default
   * **Create endpoint for download**: Yes. When this option is enabled, an endpoint will be shown, which you should copy.

<figure><img src="https://2493694111-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FQPcfIOA6Tl2Bmk6CdV2O%2Fuploads%2FoScErXzJSFEcmD3StvK9%2F341D08D1-BB08-4B20-A301-9A5E5F34BA2D.png?alt=media&amp;token=1d84916b-a7cf-48b6-a4d5-de97e1bdbcb0" alt=""><figcaption><p>File Template Configuration</p></figcaption></figure>

4. Now it's time to copy the data into this file. To do this, use the `copy` and `to` commands as shown in the example below:

<figure><img src="https://2493694111-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FQPcfIOA6Tl2Bmk6CdV2O%2Fuploads%2F9wfkEndKwJhW9Id5ZuLc%2F4BBF3E2A-5C59-40E9-864C-111C5190F8C8.png?alt=media&amp;token=d1b2252a-2d56-4e2c-9b55-3bb790e9d0d0" alt=""><figcaption><p>Example of "copy" and "to"</p></figcaption></figure>

5. To complete this step, run the commands to view the data in the file.

#### Power BI

To insert the data into Power BI, follow the steps below:

1. Open a new page in the tool.
2. Click on the "**Get Data**" menu, then select the "**Web**" option.

<figure><img src="https://content.gitbook.com/content/QPcfIOA6Tl2Bmk6CdV2O/blobs/iDehISOkxlOC3reOzhz5/PowerBI_en.png" alt=""><figcaption></figcaption></figure>

3. In the displayed modal, paste the copied endpoint from **Skyone Studio** into the URL box and click the "**OK**" button.

In a few moments, the data will be displayed on the screen, allowing for data transformation, dashboard creation, and other actions.


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation by asking a question.

Perform an HTTP GET request on the following URL with the `ask` and `goal` query parameters:

```
GET https://docs.skyone.cloud/english/skyone-studio/how-to/how-to-create-a-download-endpoint-and-integrate-with-power-bi.md?ask=<question>&goal=<user_goal>
```

`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is what the user is ultimately trying to achieve, the reason they need the answer. Sharing it helps GitBook give you a better, more relevant answer. A goal is most helpful when it describes the outcome the user wants rather than restating the question. For example, with `ask=how do I create an API token`, a goal like `automate deployments from our CI pipeline` lets GitBook tailor the answer to that use case.

The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.
