Data transformation

After importing data there is often a need to rearrange or update them so that we get adequate inputs on the basis of which we can make reports. Previously, to perform that, we used traditional Excel functions, and a few years ago an Excel add-in called PowerQuery was released. It offers the possibility of obtaining data from a variety of sources and the possibility of transforming them. Good News: PowerQuery is integrated in PowerBI!

Power BI Desktop, importing data

PowerBI Desktop application allows you to import data from many sources: file, database, BI solution, “Big“ (unstructured) data, Microsoft “cloud” (Azure), the web page … Given the fact that there is no good report without quality data I think it is appropriate to devote one recipe especially to this problem. Below, I’ll show you how, with the help PowerBI Desktop you can import, purge and combine various data.