From the course: Essential Power BI (Beta)

Unlock this course with a free trial

Join today to access over 23,400 courses taught by industry experts.

Connect to delimited files such as CSV and TXT

Connect to delimited files such as CSV and TXT - Power BI Desktop Tutorial

From the course: Essential Power BI (Beta)

Start my 1-month free trial Buy for my team

Connect to delimited files such as CSV and TXT

“

Power BI allows you to import data from delimited files, such as CSV or TXT. From the Start menu, New Query group, New Source button. Among the most common ones, here we see them. Select the path and the file and Open. For text and CSV files, the browser shows a preview of the data, as well as three preview of the data, as well as three drop-down boxes. The first one, file source, is very useful, especially when we have to adjust the code for the when we have to adjust the code for accents. Then we have the type of delimiter. You've identified it well, it's tab, but it could be any of these or custom. And then we have the data type detection based on the first two hundred rows, on the whole data set or not to detect it. We can modify according to our need in case it does not match what is predefined by Power BI. If everything is correct or after having made the changes, we accept. In this way we have connected to a text type file. We see the query with the preliminary view of the data…

Contents