It is possible to connect to many data sources using Power Query (more in this article) and SQL Server database is one of them. This article will tell you how to set connection to SQL Server table directly from Excel in few simple steps. Guide to Data Import and Connecting to SQL Server from Excel… Read More »
Did it ever happen to you that the Power BI update did not work? There might be several reasons for this problem and it is always user’s fault. We will model a few of these situations on a timesheet. Our goal is to find out why the report refresh does not perform without an error.… Read More »
This article is meant to be some kind of a tutorial. After going through it, it should be clearer to you how to create Power Bi report like this on your own. Following this, you can create basically any report you want – company operation report (timesheets, wages, investments), financial analytics (balance sheet, income statement,… Read More »
Best way to understanding of the differences between individual Power BI tools is to realize that every tool has some role in the whole processing of the final report. In standard MS Business intelligence we have tools by which we ensure data transformations (SSIS), processing of data model with data storage in relation structure (SQL… Read More »
MS Power Query is a very powerful business intelligence tool by Microsoft. As an Excel addin it can, together with Power Pivot, replace tools which were made only for experienced developers (SQL Server Integration Services etc.) The biggest advantage of this tool is the possibility to use a wide variety of connectors to data sources.… Read More »