NEW! FREE 30 Minutes MS Excel - Working with Dates Course  Watch now 

Power BITutorials

Top Ways to Import Data From Text in Power Query

1 Mins read

As you can import the data from Text/CSV, the same way you can import the data from the text file. The reason is that Power BI provides the same option to import the CSV file as well as a text file. Let us understand this with the help of below steps.

 

Import Data From Text Using Power Query

Step 1: Get data from Text

To get data from Text you should have your data in a text file saved on your PC. Then, you can easily connect within a few clicks in Power BI-

Home  >  Get Data  >  Text/CSV

Text/CSV is the same option from where you can import both texts as well as CSV data into Power Query as shown below.

GET DATA FROM TEXT

Step 2: Link the Text data into Power Query

Once you click on the connect option in Power BI, it will take you to the directory where you have saved your Text file. You just have to select the file and click on the open as shown below.

CONNECT THE TEXT DATA TO POWER QUERY

 

Step 3: Close & Apply

After clicking on Open option, the selected Text file gets open in Power Query as shown in below picture. Here, you can view the data and do the required data manipulations. After doing so, click on the Close & Apply button.

TEXT DATA LOADED IN POWER QUERY

You can learn more :

Related posts
Power BITutorials

Opportunity Analysis Power BI Dashboard

1 Mins read
Information: A software company that has two sales channels: direct and partner. The sales manager created this dashboard to track opportunities and…
Power BITutorials

Procurement Analysis Power BI Dashboard

1 Mins read
Information: It analyzes a manufacturing company’s spending on vendors by category and location. we explore these areas: Who the top vendors are…
Power BITutorials

Retail Analysis Power BI Dashboard

1 Mins read
Information: It analyzes retail sales data of items sold across multiple stores and districts The metrics compare this year’s performance to last…