How do you access data in a Text/CSV file using PowerBI?

It is quite easy as long as you have a good Text/CSV file.

I have previously used this file FFD.txt in earlier posts.

https://hodentekmsss.blogspot.com/2016/12/creating-csv-file-from-sql-server-2012.html

I am going to use the same file in this post.

Launch PowerBI and Click GetData.

Click Text/CSV submenu item. This brings up an 'Open' window as shown which lets you search through your folder system.

 Locate the FFD.txt file on your drive and click Open. The file is displayed in the PowerUI as shown.

Click Load at the bottom of the above.

 The data gets loaded as shown.

Now click on Data in the left as shown and the data is displayed.

This is all folks. It is quite easy to bring in Text/CSV data into PowerBI