# How to set up Power BI in Skyone Studio?

This documentation presents the process for configuring **Power BI** in **Skyone Studio**, explaining the available publication methods and the prerequisites for proper integration.

The goal is to guide users who want to publish data from **Skyone Studio** to Power BI, ensuring that all necessary permissions and configurations are properly set.

This guide is intended for administrators and users with publishing permissions in **Skyone Studio**, who need to connect and make data available in Power BI securely and effectively.

### **Benefits**

* Direct integration with **Power BI** for data visualization and analysis.
* Fast and secure publication via **ODBC** or **File Template**.
* Access control through permissions and IP whitelisting.
* Flexibility to accommodate different data-sharing scenarios.

### **Key Terms (Glossary)**

* **ODBC (Open Database Connectivity):** Connection standard that allows unified access to databases.
* **Data Lake:** Centralized repository that stores large volumes of structured and unstructured data.
* **Whitelist:** List of IP addresses authorized to access a specific resource.

### **Configuration Steps**

Publishing to Power BI within **Skyone Studio** is not linked to workflows. For the publication to work correctly, the user must have:

* Access permission to the **Data Lake**
* Workspace configured with **Power BI access** (all new workspaces have this permission by default).

Configuration can be performed using 2 main publication options: **ODBC** and **File Template**.\
Each method suits a specific scenario, but both allow data to be integrated into Power BI.

* [**\[ Step 01 \] Publication via ODBC**](#publishing-via-odbc)**:** Connect Power BI to the Skyone Studio database in real time.
* [**\[ Step 02 \] Publication via File Template**](#publishing-via-file-template)**:** Share Data Lake files via a public URL.

***

### **Publication**

Currently, Power BI offers two publication options:

* **ODBC (Open Database Connectivity)**
* **File Template**

<figure><img src="/files/GhHRNyZTMKkPjxLWgJxh" alt=""><figcaption></figcaption></figure>

***

### Publishing via ODBC

The ODBC option allows a real-time connection to the database. This functionality provides the necessary information such as host, port, and user credentials.

**How to configure:**

1. Go to the **Data Management** menu.
2. Click **Engine**.
3. Select the **ODBC** option.

On this screen, you can view system metrics such as:

* Total memory used
* Disk space
* CPU usage (including cores)
* Available memory and storage

<figure><img src="/files/fdGNPXJs0RYCx3lGA8cT" alt=""><figcaption></figcaption></figure>

4. Add users and, in the **Whitelist** section, enable the authorized IP addresses. This ensures that, when you click **Publish**, only these **IPs and users** will have access.

<figure><img src="/files/y8Vsj2Qm7YfbBgCRTlud" alt=""><figcaption></figcaption></figure>

**When you click ODBC during the publishing process, you will see**:

* **Host** and **Port** fields
* **IP Whitelist**: only added IPs will have access permission

<figure><img src="/files/MS0B2FBGxtlpNfQoGXAp" alt=""><figcaption></figcaption></figure>

* **Management button**: click **Manage** to be redirected to the ODBC screen

<figure><img src="/files/9N9vtgjJZPINPrrX3hen" alt=""><figcaption></figcaption></figure>

Basic connections come preconfigured. However, whitelist and user management must be done manually via the **ODBC** screen or by clicking **Manage**.

***

### Publishing via File Template

This option allows you to make Data Lake files available through a public URL, making external sharing easier.

**How to publish:**

1. Click **Publish**.
2. Select **File Template**.

   <figure><img src="/files/4BsCYC3Kew1sebuAefXO" alt=""><figcaption></figcaption></figure>
3. **Adding a New File**:

* Click the **“+”** button in the upper-right corner of the screen.

<figure><img src="/files/puk97EG5OJc24JJMeXBD" alt=""><figcaption></figcaption></figure>

* **Fill in the following fields:**

  * **Template name**
  * **Template type**
  * **Directory**
  * **File name**
  * **Read group**
  * **Write group**
  * **Tags** (if needed)

  <figure><img src="/files/BcyGa0XqdTTN49OQCOES" alt=""><figcaption></figcaption></figure>
* Enable the **“Publish File Template”** flag.

<figure><img src="/files/Ih0mtgdoULqILmmuyvfe" alt=""><figcaption></figcaption></figure>

Done! After saving, your file will be ready for download. Go to the first page and select the file, then copy and paste the URL to download it.

***

### **Demonstration Video**

To make the process easier to understand, watch the video below for a practical demonstration of all the steps covered in this documentation. The video shows each screen, click, and configuration required to complete the Power BI integration.

{% embed url="<https://files.gitbook.com/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FQPcfIOA6Tl2Bmk6CdV2O%2Fuploads%2F00ao87D1M22i6F9BHatJ%2FPower%20BI%20-%20EN%201.mp4?alt=media&token=94529c4c-65ea-41d1-8922-ce3b1b5ae164>" %}

***

### FAQ&#x20;

<details>

<summary>Is it necessary to configure permissions in Power BI to use Skyone Studio?</summary>

No, as long as the workspace already has Power BI access (new workspaces come pre-configured).

</details>

<details>

<summary>Which method is faster for publishing data?</summary>

**File Template** is faster for external sharing, while **ODBC** is ideal for real-time connection.

</details>

<details>

<summary>Can I publish using both methods at the same time?</summary>

Yes, as long as the user has the necessary permissions for both.

</details>

<details>

<summary>Is it mandatory to configure a whitelist for ODBC?</summary>

Yes, to ensure that only authorized IPs have access.

</details>


---

# 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/artificial-intelligence/agents/ai-agent-publication-channels/how-to-set-up-power-bi-in-skyone-studio.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.