Power BITutorials

Best Ways to Import Data From XML in Power Query

1 Mins read

You can easily load the data files like Excel spreadsheets in Power Query. But what if your data source is not an Excel spreadsheet? For that, you have to follow these following steps, suggested by our Power Query Training Experts. Each step is well explained with image visualization.

Data Analytics Tricks in Power BI – Guidebook

You too can analyze data like a Data Scientist. No coding needed. No statistics needed.

Analyze & Visualize data using Power BI. (23 tricks in one book)

Import Data From XML Using Power Query

It’s very usual nowadays to get data from a company’s accounting or sales system in the XML format. If the data is inside an XML file, it’s very easy to import data into the Power Query!

Let’s have a look below to see how easily we can import an XML file into Power Query:

Step 1: Get data from XML

To get data from XML you should have an XML file containing data saved on your PC. Then, you can easily connect within a few clicks in Power BI as given below-

Home > Get Data > More > XML > Connect

GET DATA FROM XML

Step 2: Link the XML data into Power Query

Once you click on the connect option in Power BI, it will take you to the directory where you have saved your XML file. You just have to select the file and click on the open as shown below.

CONNECT THE XML DATA SOURCE TO POWER QUERY

Step 3: Select the source file in Navigator

A navigator window gets open after selecting the XML file. In this window, you have to select the subfiles that you want to connect to the Power Query. Also, you can preview this file before clicking on Edit as shown below.

SELECT THE SOURCE FILE

Step 4: Close & Apply

After clicking on the Edit option in the Navigator window, the selected file gets open in Power Query as shown in the below picture. Here, you can view the data and do the required data manipulations. After doing so, click on the Close & Apply button.

XML DATA SOURCE IN POWER QUERY

Data Analytics Tricks in Power BI – Guidebook

You too can analyze data like a Data Scientist. No coding needed. No statistics needed.

Analyze & Visualize data using Power BI. (23 tricks in one book)

Related posts
AlteryxTutorials

Alteryx Hotkeys - Alteryx Keyboard Shortcuts

2 Mins read
Top 50+ Alteryx Shortcuts for Windows. Alteryx is popularly known as a Self-Service Analytics tool. Business users can build their data workflows…
AlteryxTutorials

Step By Step Guide to Learn Alteryx

6 Mins read
Alteryx Learning Path: The growth in technology has resulted in growth in understanding. In today’s world, humans – fellow businessmen know the…
Excel VBA CodeTutorials

VBA Code to Clean the Date Format

1 Mins read
When it is useful? Most of the time the most annoying problem is when the data is taken from ERP or other…

Leave a Reply

Your email address will not be published. Required fields are marked *