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: Connect Power BI to the Skyone Studio database in real time.

• [ Step 02 ] Publication 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

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

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

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

• Host and Port fields

• IP Whitelist: only added IPs will have access permission

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

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.

   
3. Adding a New File:

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

• Fill in the following fields:

  • Template name

  • Template type

  • Directory

  • File name

  • Read group

  • Write group

  • Tags (if needed)

  
• Enable the “Publish File Template” flag.

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.

FAQ