It is nothing hard to create report using Power BI desktop for example from Excel and then upload it to the cloud on powerbi.com. But how to update the...
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...
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...
FILTER functions (filtering functions) are used to get values from the table. Some functions enable additional filtering in a given table. These functions are often part of different functions...
Aggregate functions in DAX language are used to get certain summarized or grouped data view. Thanks to this, we can edit high detail data in a certain column into...
CALCULATE is an important function for a large number of calculations and for those of you who actively do DAX formulas in Power BI or PowerPivot. Understanding of how...
Function REALTED is very frequent and useful in DAX language. We can use it for example when we need to search table (A) for value from other table (B)....
You probably noticed that there are many functions in DAX that are similar to Excel ones (as in article here). Contrary to Excel functions, DAX haves on strange thing....
We can create two types of new values using DAX in Power BI or PowerPivot. They are calculated measures and columns. Difference between measure and column and its understanding...
DAX language (Data Analysis Expressions) servers for data management and editing prior reporting in Power BI or Powerpivot, similarly to function set in Excel. This language is able to return...
DAX language haves its standards as does any other language. This article sums up and describes how look the parameters of formulas. In other words, this article is about...
Email from MS landed in my inbox few days ago. It states that Power BI introduces new product called Power BI Premium valid since 2Q 2017. Hand in hand...
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...
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....
Powerpivot in excel is an add-in automatically pre-installed in MS Office 2013 + (all you need to do is add it to the ribbon). It is not present in...
Powerpivot is an excel add-in enabling data modeling and analysis in familiar Excel environment which is certainly an advantage. Import big amounts of data through Power Query and connect...
What I will show you in this article is how to use Power BI to connect to your favorite web performance monitoring service Google Analytics. It is true that...
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...
Power BI is a cloud technology by Microsoft which enables user to analyze and visualize data easily. Creating reports is a task anyone can do. You do not have...