Obtener datos de un archivo de texto a Power BI

In this study, we show you how to connect Power BI to text files and how to get data from a text file to Power BI. To demonstrate getting data from a text file to Power BI, we will upload data from a text file to Power BI and generate a column chart.

How to get data from a text file to Power BI

Before we start getting data from a text file to Power BI, let's look at the data present in the employee's text file. In the following screenshot, you can see that it is just a normal text file. If you look closely, the First row has the column names

get-data-from-text-file-to-power-bi-1-9348538

If you haven't started Power BI Desktop yet, double-click Power BI Desktop to open it. Once it's open, it looks like the screenshot below. Click on the Get information Hyperlink

connect-power-bi-to-sql-server-1-1617761

If you are on the Power BI visualization page, on the Home tab, click the Get information option and select the Text / CSV, as we show below. Or select More options.

get-data-from-text-file-to-power-bi-2-2837425

Get data from a text file to Power BI

When you select the More option, the following window will be displayed. You can use this window to select the data source you want. For now, let me select the Text / CSV Option and click Connect button

get-data-from-text-file-to-power-bi-3-4091878

Once you click on the Connect , a new window opened to select the text file from our file system. For now, we are selecting the Employee.txt file, as shown below.

get-data-from-text-file-to-power-bi-4-5648802

Wait until the connection is established

get-data-from-text-file-to-power-bi-5-1607636

Now you can see the preview of the data present in the text file.

get-data-from-text-file-to-power-bi-6-4774641

Most of the time, Power BI automatically selects the delimiter and separates the columns. If this is not the case, use the Delimiter option to change according to your requirements.

If you are satisfied with the data and data types, click the Upload button; otherwise, click the Edit button to make changes.

get-data-from-text-file-to-power-bi-7-4692375

Clicking the Edit button opens the following window. Use this window to change the data according to your needs.

get-data-from-text-file-to-power-bi-8-1308034

Currently, we do not want to make any changes to the data. So let me click on the Load button

get-data-from-text-file-to-power-bi-9-1777544

Now you can see all the imported columns from the text file below the Fields section.

get-data-from-text-file-to-power-bi-10-6194501

Let me create a column chart with this data. I suggest you check out the Column Chart in Power BI article to understand the steps required to create it.