Power Query gives us the ability to combine multiple files which belong to one folder. These can be TXT or CSV files, but in practice we will usually combine several Excel files. This is a very powerful option that can save us a lot of time. At the same time, it brings with it some challenges, which you will be able to learn more about in the following text …
One of the phases of the project for the implementation of ERP information systems is retrieving data. These can be master data (partners, contacts, pricelists, etc.) or financial data. Most of them are retrieved from the company’s old information system, which is often exported as TXT or CSV files. Excel has a mechanism for retrieving entire files and manipulating data, which will be discussed in the text that follows …
Often it happens that different groups of executors fill in the tables that have the same structure, and differ only in the data they contain. Sometimes it is necessary to merge more of such tables into one, and Power Query is the ideal tool for performing such job. Let’s see how we can add the contents of one table to another.
Power Query is indeed powerful Excel add-in that allows retreiving data from different locations, changing them and preparing for further processing. Data sets are retrieved by creating queries to the data source, and the result of each query is stored in a separate table. Sometimes it is necessary to merge the results of two queries. The following text will explain how this works.
PowerBI Desktop allows you to obtain data from different sources. They are being acquired into tables between which we later create relationships to create the Data Model. Sometimes it is necessary to have temporary table that needs to be used to create a specific report. To create such a table and manually fill it, you can use the Enter Data option.