# 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="https://2493694111-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FQPcfIOA6Tl2Bmk6CdV2O%2Fuploads%2F7Dy9KgNiJLCv2pO3Emge%2FfejKC4V0kC.png?alt=media&#x26;token=60f64229-3e50-4056-83ce-e132843fe70a" 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="https://2493694111-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FQPcfIOA6Tl2Bmk6CdV2O%2Fuploads%2F8lHa6wCvEkNPAUWxOvwt%2FNsyDFpHkQP.png?alt=media&#x26;token=c4ab4d9b-aaa4-4fca-a9f3-71336315a2e0" 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="https://2493694111-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FQPcfIOA6Tl2Bmk6CdV2O%2Fuploads%2FM50akODWZ1SjhQfR0H6b%2FDcicNVKJGB.png?alt=media&#x26;token=b23c57f4-7074-460b-8c83-5236b81a071f" 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="https://2493694111-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FQPcfIOA6Tl2Bmk6CdV2O%2Fuploads%2FdxJjlpdPVYvnRniTMK1z%2FiiYS8EqgG1.png?alt=media&#x26;token=1289cc6c-3aa7-4268-9458-5f58c3b57081" alt=""><figcaption></figcaption></figure>

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

<figure><img src="https://2493694111-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FQPcfIOA6Tl2Bmk6CdV2O%2Fuploads%2FiYEzQLC5qqeuEqFVffLL%2Fi1M8aNFIfC.png?alt=media&#x26;token=c565b684-c1d3-4abe-9b57-88cc9261eaf0" 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="https://2493694111-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FQPcfIOA6Tl2Bmk6CdV2O%2Fuploads%2Fgz6Rf1dPfYX9zrRcxz40%2FwTDo7bJA6L.png?alt=media&#x26;token=06df22b0-de65-4dff-966b-903cc26e083e" alt=""><figcaption></figcaption></figure>
3. **Adding a New File**:

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

<figure><img src="https://2493694111-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FQPcfIOA6Tl2Bmk6CdV2O%2Fuploads%2FNtR8OXdAnm99Yxa6moW4%2Fimage.png?alt=media&#x26;token=203224d8-2984-4511-b0e5-c38db155aa8a" 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="https://2493694111-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FQPcfIOA6Tl2Bmk6CdV2O%2Fuploads%2Fb6csOnCaBeCzqJizftzF%2Fimage.png?alt=media&#x26;token=ef5ede98-d0fd-4f82-bfd3-a5cf9cb68cfa" alt=""><figcaption></figcaption></figure>
* Enable the **“Publish File Template”** flag.

<figure><img src="https://2493694111-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FQPcfIOA6Tl2Bmk6CdV2O%2Fuploads%2FhHqf4EbOJ46pJVv4eSeM%2Fimage.png?alt=media&#x26;token=cb07723d-04d5-4e0d-9846-c099385fccc1" 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>