Loading Data From Different Sources In Power BI

Section — 5

In this article, we will learn about how we load data from different sources in power bi and we also explore different files formats for better taste.

Topics Covered:

• How to load XML data file
• How to load excel data file
• How to import queries and models created in excel

How to Load XML Data File

• Click the “Get Data” button on the home ribbon. This will generate a get data dialog box.
• Select “XML” among the options given.
• Click “Connect” to leave the dialog box.
• On the windows dialog box generated, find your XML file and click “Open”.
• A navigator dialog box will open and you will be required to select the dataset you want to load. To choose a dataset, click on the check box beside the name. The contents of the selected dataset will be displayed on the right side of the dialog box.

How to Load Excel Data File

• To make a shortcut from the normal process click on the small triangle button directly below “Get Data” .
• From the small generated, Click “Excel”.
• Locate the file you want to upload and click “Open”.
• Like XML excel can contain multiple datasets at one. Click on the datasets, you want to upload to enable the load and edit button.
• Edit the file in the query window by click the “Edit”, access the file immediately on power bi by clicking “Load”.
• The datasets selected can be accessed in the fields column on the right side of the power bi desktop data window.
• Power bi does not work directly with excel workbooks, so it will only extract the items in the file that are compatible with power bi operating systems.
• From the data imported from the excel file, power bi will create a different file which contains the compatible items.
• The importing and file creation process will take a few minutes.
• Under the message there are two buttons “Start” and “Cancel”. Click on start to begin the import process.
• You will be able to see the progress of the importing process. Once the process is completed, Power BI will display the summary of the items imported. When you are done checking the items that successfully imported, Click close to exit the summary dialog box.

Import Queries And Modules Created In Excel

• Open your power bi desktop app and exit the splash screen.
• Click the file tab on the ribbon.
• From the drop-down menu created click “Import”.
• From the options listed in the import menu, “Click” excel workbook contents. This will generate the windows open dialog box.
• Locate the file containing your power pivot and power view data and double click on it to open.
• Once open the files, power bi will display a message while importing the file.

Conclusion

When we as a team running any sort of business in current challenging market

so as a better business person we need to choose a best business intelligence

tool that help us to shape out our business constraints and also figure out the problems that comes up after the intervention of humans so Power BI comes up with a different stance and through power bi we play with our raw data and explore it from every corner.

If you liked it, show your love by clapping and responding. Follow us.