If you want to know how to load .csv data into Power BI, read this post. In Power BI, there are several sources of getting data and the most popular of them is Excel. In addition to it, text files, .txt or .csv, SQL, Azure, SAP and Sales Force databases are widely used.
Knowing how to get data from csv files in Power BI is critical. Because, various business software export data in this file extension. Therefore, there will often be a need to open the csv in Power BI.
In this post, we will guide you through the necessary steps to learn how to pull data from a csv into Power BI. So, follow the steps below and let us know in the comments if you were able to import .csv into Power BI.
How to import .CSV files into Power BI Desktop
To connect Excel to Power BI and be able to process the data, follow the steps below:
- Click the Home tab.
- Find the Data group.
- Click the Get Data button.
4. Click Text/CSV.
- Select the csv file.
- Click the Open button.
- Choose source character encoding.
Note: The character encoding of the .csv file source serves to correctly display language special characters, such as the Cyrillic alphabet, for example.
- Choose the data delimiter.
Note: The data delimiter is used to separate the information contained in the file by columns in Power BI. Different systems use different delimiters.
- Click Load.
After following the steps above, the csv data will be inside Power BI.
Summary
Learn how to import data into Power BI that is stored in .csv files.
So, follow the steps above and let us know in the comments if you were able to load .csv data into Power BI.