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.

Power BI, publishing on web

Companies sometimes have the need to publish reports that are of importance for the various concerned parties (customers, suppliers, shareholders, banks) such as balance sheet, income statement, inventory… If you connect with ERP or BI solution, and further import data to PowerBI and create reports and dashboards, there is an option to generate a link for sharing PowerBI reports on external web site.