Skip to main content

Import CSV In Power BI

 

Import CSV file

Click on Get Data à More à File option and select Text/CSV. Navigate to the CSV file which needs to be imported

FL_insurance_sample.csv . Select the file and click on Open.

FL_insurance_sampleDownload

In the CSV window on top we have 3 dropdowns, preview of data and data load options.

 Select Load and it will load to power query editor window.

CSV

In the Power query editor the CSV file is loaded as a Queries. In power query editor we can edit, clean and transform the file as required.

3 Dropdowns and Data Load

File Origin – Type of file origin. By default its 1252 Wester European (Windows). It’s the file type as per OS and region and country.

Delimiter – Delimiter for column separation. By default it detects the delimiter from data , If the delimiter is not from the default options then we can select custom delimiter.

Data Type Detection – By default it detects data types of columns based on top 200 rows, we can select entire data or do not detect data type

Data Load Options

Load -  It will directly load the data to power query

Transform – It will allow to transform the data before loading it to power query

Labels:

Comments

Post a Comment

Popular posts from this blog

Metabase - Open Source BI tool

 Metabase          Metabase is a business software suite and open source business intelligence framework. It allows users to store data about their business or a specific aspect of their business for their analytics in a secure data source. This intuitive software is designed to allow users to ask questions about their data and access answers that reduce jargon and code, making it very user-friendly and ideal for professionals who want to visualize their business’s data accurately                    Install in docker https://github.com/punitprabhu/MetabaseNew.git         Excecute in CLI docker run -d -p 3000:3000 --name metabase metabase/metabase         Host http://localhost:3000 ,           http://localhost:3000/browse/1-sample-database                         ...
Post a Comment
Read more

Quantum Computing

  Quantum computing is a new kind of computing that uses the laws of quantum physics to solve certain problems much faster than classical computers.  It doesn’t replace your laptop but can tackle very complex simulations, optimization, and cryptography‑style tasks that are intractable for ordinary machines.  *** ### What is quantum computing? Quantum computing is a computing paradigm that uses quantum‑mechanical phenomena—like superposition, entanglement, and interference—to represent and process information in new ways. Instead of classical bits (0 or 1), quantum computers use **qubits**, which can be in a mix of 0 and 1 at the same time, enabling parallel computation.  *** ### Classical bits vs. qubits - A **classical bit** is either 0 or 1; operations are deterministic and sequential.  - A **qubit** can be 0, 1, or any quantum “blend” of both, written as $$ \alpha|0\rangle + \beta|1\rangle $$, where $$ \alpha $$ and $$ \beta $$ are complex numbers capturing p...
Post a Comment
Read more

How to Choose a BI tool

 How to choose a BI Tool                                          In the process of choosing a Business Intelligence (BI) tool, here is a list of seven key capabilities that are recommended to consider. These capabilities will help you evaluate and select the best BI tool that aligns with your specific business criteria and goals:                            Data integration              Data management              Data warehouse              Data analysis              Data visualization              Automation              Data security              Licensing Cost...
Post a Comment
Read more