Blog

Drillthrough Filter In Power BI – A Quick Guide

09-June-2019  0 Comment(s)

In all the time that I have been using PowerBI, I noted that the reports were always filled up with data and there was little to no space to add details about any sort of entit



Power BI - dataflows

07-June-2019  0 Comment(s)

Solution
According to Microsoft this new addition is for self-service ETL by business annalists and BI professionals. A minor addition from our side: especially business annalists that are skilled with tools like Excel and BI professionals with already a focus on Power BI will probably be



Installing Power BI On-Premise Server

31-May-2019  0 Comment(s)

The Power BI On-Premise server is a real and true BI report Portal is a tried and proven reporting portal solutions for your organization. Coming from a long history of enterprise reporting from the SQL Server Reporting Services reporting portal, Microsoft has done a great job by improving SSRS w



R With PowerBI: A Step-by-Step Guide

30-May-2019  0 Comment(s)

There's been a lot of interest everywhere on how to integrate R scripts with Microsoft PowerBI dashboards. Here is a step by step guide to this.

Lets assume that you have some readymade R code available, for example, with the ggplot2 



DATEADD() and other Date Tips for Filtering Data in Power BI

13-May-2019  0 Comment(s)

While working with Dates in DAX, you may have come across an interesting behavior when working with the DATEADD() function. If have used this function in SQL, you have a good idea of how the function works and the parameters you pass to it in order to shift a date forward or backwards. However, t



CALCULATING QUARTILES WITH DAX AND POWER BI

12-May-2019  0 Comment(s)

The PERCENTILEX.INC function returns the number at the specified percentile. So for example, if I had numbers 0 and 100 in my data set, the 25th percentile value would be 25. The 50th percentile value would be 50 and the 75th percentile value would be 75, and you can figure out what the 100th per



Power BI Dataflows

23-April-2019  0 Comment(s)

Data is loaded via a web-based version of Power Query, which is why this capability is referred to as self-service data prep. The resulting data is stored in Azure Data Lake Storage Gen 2. Once in the Common Data Model in the data lake, it can be reused among various Power BI datasets -- allowing



How to find a Dataset ID in Power BI

22-April-2019  0 Comment(s)

Today, I had to get a single dataset ID from a report I had deployed to the Power BI Service. I quickly realized I had no idea where or how to get it! Turns out, it’s super easy to find – if you know where to look :)

Since I had to click around for a bit, do some searches, a



Merge Operations in Power BI / Power Query

14-April-2019  0 Comment(s)
  • then we find the file that we downloaded (with the name of Sample Data.xlsx). We then select the option to “Select multiple items” and we select both the ExportedData and ExclusionTable tables:
  • ExportedData – similar to the previous post,


DataOps is NOT Just DevOps for Data

04-April-2019  0 Comment(s)

One common misconception about DataOps is that it is just DevOps applied to data analytics. While a little semantically misleading, the name “DataOps” has one positive attribute. It communicates that data analytics can achieve what software development attained with DevOps. That is to



Power BI and PowerShell - Update Dataset

03-April-2019  0 Comment(s)

Power BI offers a REST API for embedding, administration, and user resources. In this post I walk you through how to refresh a dataset with PowerShell. 

 

Prerequisites

To be able to run a PowerShell script to update a Dataset in Power BI you have to



Relationships with a many-many cardinality in Power BI Desktop

22-March-2019  0 Comment(s)

With the relationships with a many-many cardinality feature in Power BI Desktop, you can join tables that use a cardinality of Many to Many. You can more easily and intuitively create data models that contain two or more data sources. The relationships wi



Yammer Analytics In Power BI

12-March-2019  0 Comment(s)

Let’s imagine your organization is using Yammer as an internal platform for digital collaboration, engagement, knowledge sharing etc.

It is a large international organization with employees around the globe (think big).

I have access to Yammer in one of such organization



10 reasons why Power BI

09-March-2019  0 Comment(s)

1)     Unlimited access to on-premise and in-cloud data

2)     Interactive and stunning visualisations you can share with wide audiences

3)     Immediate and fr



Power BI Basic Filters

06-March-2019  0 Comment(s)

Visual Level Filters: This includes Filters on Dimension, Filters on Measures, Basic Filters, Advanced Filters, and Top N filters
Page Level Filters: Theses Page Level Filters will apply to all the visuals present in the current page.
Drill through Filters: This Drill through Filter



Power BI Dataflows

25-February-2019  0 Comment(s)

One of the compelling features of dataflows is the ease with which any authorized Power BI user can build semantic models on top of their data. Because dataflows already store data in CDM folders, the integration between Power BI and Azure Data Lake makes it possible for any authorized person or



What is Filter Context?

22-February-2019  0 Comment(s)

There are a couple of fundamental concepts that one must learn in order to build effective reports in Power BI and Power Pivot. One of the core concepts is filter context. What is filter context? It is a little confusing if you are coming from an excel background. The easiest way to think about i



What is Filter Context?

22-February-2019  0 Comment(s)

There are a couple of fundamental concepts that one must learn in order to build effective reports in Power BI and Power Pivot. One of the core concepts is filter context. What is filter context? It is a little confusing if you are coming from an excel background. The easiest way to think about i



Power BI Gateway Connection and Managing Gateways

16-February-2019  0 Comment(s)

1. PowerBar Web will schedule the refresh of the screen (automatically can define defined in the hours that we set as data sources to increasingly data update.) Report DATA SETS menu ... clicked section and RENEWAL of TIME (Schedule Refresh) is selected.

If you want to update the data m



Custom Visuals For Power BI

11-February-2019  0 Comment(s)

The Custom Visuals in Power BI are considered as one of the prominent factors for awesomeness in Power BI. As a developer you can create your own Custom Visuals here, and publish them to AppSource (aka the marketplace).

Report producers can load Custom Visuals into their Power BI report



Import Power BI Desktop Model to SSAS Tabular 2016

06-February-2019  0 Comment(s)

How it works?

The idea is to

  1. Connect to Power BI Desktop model from SSMS 2016
  2. Script the model
  3. Modify the script
  4. Execute the scripts on your on-premises instance of SSAS Tabular 2016
  5. Open the new SSAS Tabular database in SS


Refresh date\time in a Power BI report and dashboard

29-January-2019  0 Comment(s)

Show last refresh date\time

To show the date and time of the refresh we need to store the date and time of the time refresh runs in the model itself so we can show it in a visual.

One of the easiest options is to use Power Query to store the current date\time as a table. I s



Conditional Column in Power BI

24-January-2019  0 Comment(s)

Power BI Conditional column generate a new column based on the condition that we specify. For example, creating an appraisal column based on the employee performance etc. In order to add conditional column, please click Edit Queries option under the Ho



What are Data Flows

23-January-2019  0 Comment(s)

The new Azure Data Factory (ADF) Data Flow capability is analogous to those from SSIS: a data flow allows you to build data transformation logic using a graphical interface. A really interesting aspect about ADF Data Flows is that they use Azure Databricks as the runtime engine underneath -- howe



DAX Measure Dependencies in SSAS Tabular and Power BI

21-January-2019  0 Comment(s)

DAX measures are the heart of every SSAS Tabular model, Power BI and Power Pivot solution. You write lots of DAX measures and you potentially reference some of them in other measures. So the number of DAX measures you write and reference them via other measures grow very quickly. Especially in co



DAX Measure Dependencies in SSAS Tabular and Power BI

13-January-2019  0 Comment(s)

DAX measures are the heart of every SSAS Tabular model, Power BI and Power Pivot solution. You write lots of DAX measures and you potentially reference some of them in other measures. So the number of DAX measures you write and reference them via other measures grow very quickly. Especially in co



PBI Report Template With Custom Calendar

10-January-2019  0 Comment(s)

Power BI report templates are amazing as starter reports. They can be built with or without data sets. Design practices such as a standardized calendarcompany logo, visualization arrangement, backg



80% to work hard and 20% PowerBI

18-December-2018  0 Comment(s)

POWERBI has 80% to work hard and 20% to see has made one of the best in Business Intelligence.

 



POWER BI Slicer vs Filter

09-December-2018  0 Comment(s)

Although very basic but many folks are not able to answer this in the interviews, which is better Filter or Slicer? 
 
Answer is it depends, a slicer is an alternate way of filtering but you do not have to pick one from slicer or filter, both complement each other that is



PowerBI-The game changer

04-December-2018  0 Comment(s)

Power BI is made up of various technologies and has developed slowly. Microsoft uses confu



Remove errors with Power Query

02-December-2018  0 Comment(s)

Are you experiencing an issue when unpivotting Excel data?

Unfortunately as soon as you try to Unpivot a table of data containing a #DIV/0 or #/NA you get a very strange warning….

This is totally misleading, however the “More Details:” part of the message do



Calculate Working Days without Holidays for specific states in country

26-November-2018  0 Comment(s)

Recently I have a task to modeling for “Client Turnaround Report”. In this report, I need to calculate turnaround duration by counting all working days between appointment’s event date and finalization date. The problem is that working day is defined by:



Counting active products/clients/specialist over related dimensions

23-November-2018  0 Comment(s)

There is a simple question that could be asked in any industries for business understanding: how many active products so far? or how many new/active clients we have in this year/month?. Active products/clients is a term to describe the clients/products that is appeared in recently transactions. I



Relationship views

23-November-2018  0 Comment(s)

 

This will be simple task if customer’s age is calculated by current yea



WE ALWAYS WORK WITH :