# 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. 

In this documentation, we will detail step-by-step how to use the "[File Template](/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](/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="/files/oR1g47IkhIY0uIFqmj6o" 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="/files/RqeVDUxy91jUcqDjBcqQ" 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="/files/rhz6DCg5jmjXjGSC3N5o" 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: Querying This Documentation

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

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

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

The question should be specific, self-contained, and written in natural language.
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.