How to load Text or CSV files into Power BI
This paper lays out the process for getting text and CSV file data into Power BI . It gives you two options, step by step : you can either load the data directly or transform it using the Power Query Editor. The whole point of this guide is to make the import process simple to understand and help you decide the best approach for prepping your data. This is how you get your text or CSV file data into Power BI, step by step. 1. Get Data Action : On the Home tab in Power BI Desktop, click the "Get Data" button. Selection : From the list of data sources, select "Text/CSV". 2. Select File Action: A file explorer window will open. Selection: Navigate to the directory containing the desired .csv file. 3. Preview and Settings Action: A CSV connection preview window appears, displaying a sample of the data from the .csv file. Verification: Review the settings in the preview window to ensure they are appropriate for your data. Key ...