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.
In one of the earlier posts I wrote about that PowerBI comes in many “flavors”: as a Cloud Service (PowerBI.com) as a development environment (PowerBI Desktop), as application for mobile devices available on Windows, Android and iOS platforms (PowerBI Mobile). Since the majority of you who are reading these lines deal with reports development I decided to demonstrate you, in a practical example, how to use PowerBI Desktop.
PowerBI is the Microsoft Cloud service that allows you to download data from different sources, their storage and processing in order to generate vivid reports that an be seen on almost every platform imaginable. This is a tool that Microsoft has high hopes on and which is developing at an incredible rate. Every month there is a new version that fixes bugs and brings new functionalities.