Microsoft has finally released the September 2017 Update for Power BI Desktop with a ton of exciting features added in the Reporting area. There are five major features contain in this release which makes Power BI strong enough to choose over other self service BI vendors. We will discuss each of these one by one. …

DAX (Data Analysis eXpressions) introduces the functions RELATED and RELATEDTABLE for following & navigating through the chain of relationships in Power BI, Power Pivot & SSAS Tabular and It is used to retrieve related data from another table. Both of these functions are more powerful than VLOOKUP in Excel in a couple of ways. First, …

Traditionally, business intelligence projects tend to use a star (Kimball) or snowflake(Inmon) schema; a design approach that has become the de facto design standard for data warehouses and cubes over the last few decades. Below is an example of a star schema: The center of the star is called the fact table. It describes the …

In today’s post, we will learn two new techniques to load the Power BI Desktop data to the SQL Server or any other ODBC database. Technique 1 : Using R Script in the Query Editor Window  In this technique, we will leverage the power of R in the Query Editor. You can use R script …

Power BI Team has finally released the August 2017 update for Power BI Desktop and It came up with the balance of few essential features which was pending since the long time to fill the visualization customization gaps &  few new features to enhance the data modelling experience. It’s good to have updates every month! …

Sometimes, It is required to Copy & reuse the ready made calculations in your Power BI Model without understanding the logic behind the scene. Even, Power BI Desktop June 2017 Release now features ready to use measures that can be applied to your data model. Having a compiled list of these measures gives you the …