PowerBI

Ben Richardson
A bar chart which is the output of applying the advanced filter

Power BI Visuals: Working with Filters

August 18, 2020 by

Power BI is a data analytics tool that can be used to analyze data with the help of Power BI visuals.

Power BI is a Microsoft application and is available as a desktop application as well as a cloud service. It comes with a variety of visual and filtering options that can be used to create Power BI visuals.

Read more »
Ben Richardson
Selecting the treemap visualisation to add on to our report.

Power BI Visuals: Working with Treemaps and Tables

August 6, 2020 by

In this article, you will learn how to work with Treemaps and Tables, which are two of the most commonly used Power BI visuals. You will also see how slicers can be used in Power BI to dynamically update the data in Treemaps and Tables. Power BI Visuals are extremely easy to create and don’t require you to write any code.

Read more »
Aveek Das
Power BI Report

Working with Power BI Data Models in Visual Studio Code

July 30, 2020 by

In this article, I am going to introduce the Tabular Object Model (TOM) in the Power BI Data Model and provide an understanding of how this model can be accessed outside of the Power BI environment. For more info about the Tabular Object Model in the Power BI Data Model, please read this article. In this tutorial, we are going to use the Visual Studio Code to simply write a dotnet console application and try to access the Tabular Object Model from the Power BI file. With the help of this knowledge, programmers and BI developers can not only view the underlying model in the Power BI Data Model but also can enhance the data model programmatically by writing a few lines of code. It can also be further improved by automating the creation of the Power BI models with the help of the Tabular Object Model library in dotnet.

Read more »
Aveek Das
Creating the report from the Data Model

Migrate Power BI reports between multiple workspaces

July 14, 2020 by

In this article, I am going to explain how we can create a Power BI Report using the Power BI Desktop and then publish it to the Power BI service workspace. Once the report is published to a workspace, we can also consider migrating the same report across several workspaces and all this can be done programmatically by using the Power BI REST APIs. This article is specially targeted towards Power BI admins or DevOps team whose task is to migrate dashboards between various environments like Development, QA, Production, etc. without any manual intervention of the reports.

Read more »
Aveek Das
Add users to Power BI

Add users to a Power BI workspace using PowerShell

July 6, 2020 by

In this article, I am going to explain how to add users to a Power BI workspace using Power BI PowerShell. As you already know, Power BI is a business intelligence tool from Microsoft, using which we can build graphical reports and dashboards which bring some sense to our data that resides on the database. Power BI also has a web interface known as the Power BI service, which can be used to share and collaborate these reports and dashboards with multiple users within or out of the organization.

Read more »
Aveek Das
Edit Parameters

Getting started with parameterized Power BI reports

June 16, 2020 by

In this article, I am going to explain how we can develop parameterized Power BI reports locally and then migrate the same report across multiple environments, like development, QA, and production. Parameterized Power BI reports are essential because we can use the same report to develop the charts and the KPIs and then provide the same report to the QA who will test it on a separate environment and finally when the testing is completed, it can then maybe provided to an administrator who can publish it to the production workspace.

Read more »
Aveek Das
Creating the Date Dimension in Power BI

Using a Date Dimension Table in Power BI

June 5, 2020 by

In this article, I am going to describe how to use a date dimension table in Power BI. Using a date dimension table becomes extremely important while visualizing facts and figures over some time in the calendar. Sometimes it is possible that we do not have the continuous date values in our dataset that we are trying to work upon.

Read more »
Aveek Das
Microsoft Power Platform - Virtual Agents

A quick overview of the Microsoft Power Platform

June 2, 2020 by

In this article, I am going to explain the various products offered by the Microsoft Power Platform. Microsoft Power Platform is a group of products offered by Microsoft to develop and build complex business solutions, analyze, and draw data visualizations, automate a business process, or build virtual agents for communication. All these products offer a platform in which no code is required to build the applications. These products are in the form of simple GUI which can be used by any business users or developers, thus helping to reduce the need for IT in the organization.

Read more »
Aveek Das
Power BI File Generated

Programmatic access to Power BI PowerShell commandlets

May 25, 2020 by

In this article, I am going to demonstrate how to access the Power BI PowerShell commandlets. In the previous article in this series, we discussed how to programmatically access the Power BI Service using the REST APIs available. PowerShell is one of the most frequently used and preferred ways of automating monotonous manual jobs and scripting those. PowerShell comes integrated with Windows, so it can be easily used from any Windows machine.

Read more »
Aveek Das
Get Datasets in Workspace

How to access Power BI REST APIs programmatically

May 19, 2020 by

In this article, I am going to explain how to use the Power BI REST API to programmatically access the Power BI Service features. I’ll also discuss the basis of REST API and how to use the APIs using Postman. Using the Power BI REST API, you can programmatically manage the administrative services like getting a list of dashboards and workspaces, refreshing a dataset, copying a dashboard from one workspace to another, and so on.

Read more »
Aveek Das
Viewing Data as North America

Introduction to Row-Level Security in Power BI

April 15, 2020 by

Analyzing data with Power BI has always been fascinating to me. With ever-growing data comes more risk, and hence more security is needed. In this article, I am going to introduce what row-level security in Power BI is and how does it work. I’ll also demonstrate in detail how to implement the same in Power BI Desktop. Later, we will also discuss how to implement this row-level security in Power BI service as well. To learn about row-level security in SQL Server, please have a look at my previous article, where I have explained how to implement the same.

Read more »
Aveek Das
Map Chart Types in Power BI

An overview of Chart Types in Power BI

April 9, 2020 by

In this article, I am going to give an overview of the most widely used chart types in Power BI. Power BI, as everyone might be aware, is one of the SaaS offerings from Microsoft in the field of BI and Analytics. It provides a very intuitive way for non-technical users to do analyses and create reports on their own without having to rely on a technical team. One of the main purposes of Microsoft behind Power BI is to promote self-service BI and it is one of the BI tools in the market with a comparatively lower learning curve as there are many similarities compared to Microsoft Excel.

Read more »
Rajendra Gupta
Title in Power BI Desktop

Scroller visual for Stock price movements in Power BI Desktop

March 31, 2020 by

In the article, Candlestick chart for stock data analysis in Power BI Desktop, we explored Power BI Desktop to analyze stock prices. If you follow the stock market, you might have noticed a ticker (similar to the following image) showcasing stock prices and changes since the last close price. It shows an up and down indicator depending upon the positive or negative change in the stock price.

Read more »
Aveek Das
Managing the Data Gateway

Setting up Power BI Data Gateway

March 19, 2020 by

In this article, I’m going to explain what a Power BI Data Gateway is and how to set it up. I’ll also cover the underlying architecture that the gateway uses and how to manage on-premise data using the Data Gateway.

Read more »
Aveek Das
Conditional Formatting in Power BI Applied

Conditional formatting in Power BI

March 18, 2020 by

In this article, I’m going to explain what conditional formatting in Power BI is. Conditional formatting, as the name suggests, is a way of visualizing data that applies special format rules based on some pre-defined conditions on the values of a selected metric. It is mostly used when the data is presented in a tabular format; however, it can also be used in any charts such as bar charts, line charts, etc.

Read more »
Nisarg Upadhyay
Data loaded in the Power Query editor

How to access data from Azure Blob Storage using Power BI

March 17, 2020 by

In this article, I am going to explain how we can access the data from the Azure Blob Storage using Power BI. To do that, we are going to use the below tools:

  1. Azure BLOB Storage account: We have uploaded the source CSV file to it
  2. Power Query editor: To choose the data that we want to load in the Power BI report
  3. Power BI Desktop: To view the data imported from the CSV file
Read more »