How to create a download endpoint and integrate with Power BI

Context

Imagine you've processed data in a table using Skyone Data 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" 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. 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.

File Template Configuration

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

Example of "copy" and "to"

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

1. In the displayed modal, paste the copied endpoint from Data 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.