In this article, you will look at Power BI Waterfall charts and see how they can be used to plot distributions of numeric data against categorical data. You will also see how you can combine multiple charts in reports view to create Power BI combined visuals.
Read more »PowerBI
Power BI: Conditional formatting and data colors in action
January 14, 2021This article shows you how to use Power BI conditional formatting and apply different color schemes to reports in the Reports View of Power BI desktop. The same process can be applied for Power BI conditional formatting in the cloud.
Read more »Power BI: Importing data from SQL Server and MySQL
January 12, 2021Microsoft Power BI is a data analytics and visualization tool that can be used to visualize data in the form of different types of reports, without writing a single line of code.
Read more »Introduction to the Power BI Service
December 24, 2020Microsoft Power BI is a data analytics tool available in two flavors: Power BI Desktop and a Power BI Service.
Read more »Extract column information using the Extract function in Power BI
December 3, 2020In this article, you will see how to use the Extract function in Power BI to extract information from columns in a Power BI dataset.
Read more »Importing data from JSON files and Power BI Rest APIs into Power BI
August 27, 2020In this article, you will see how to import data from JSON files and Power BI Rest API into the Power BI environment.
Read more »Power BI Visuals: Working with Filters
August 18, 2020Power 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 »Power BI Visuals: Working with Treemaps and Tables
August 6, 2020In 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 »Working with Power BI Data Models in Visual Studio Code
July 30, 2020In 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 »Migrate Power BI reports between multiple workspaces
July 14, 2020In 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 »Add users to a Power BI workspace using PowerShell
July 6, 2020In 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 »Getting started with parameterized Power BI reports
June 16, 2020In 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 »Using a Date Dimension Table in Power BI
June 5, 2020In 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 »A quick overview of the Microsoft Power Platform
June 2, 2020In 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 »Programmatic access to Power BI PowerShell commandlets
May 25, 2020In 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 »How to access Power BI REST APIs programmatically
May 19, 2020In 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 »Creating a visualization in Power BI Report View
May 14, 2020The Report View in Power BI can be used to create beautiful visualizations in Power BI.
Read more »Differences between the M Language and DAX in Power BI
May 14, 2020Microsoft Power BI supports two different languages, M language and DAX (Data Analysis Expression) that can be used to filter, manage, and visualize data.
Read more »Calculate Moving Averages in SQL, Power BI and MS Excel
April 21, 2020In this article, I’m going to talk in detail about the moving average in SQL and how to find out the same in Power BI and Excel. This might be a new topic for many newbies who have started out in this field, but I’m sure this will help anyone who is trying to work on smoothing averages in SQL or in Power BI.
Read more »Introduction to Row-Level Security in Power BI
April 15, 2020Analyzing 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 »An overview of Chart Types in Power BI
April 9, 2020In 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 »Analyze coronavirus data with Power BI Desktop visualizations
April 6, 2020This article gives you an overview of representing coronavirus spread using Power BI Desktop visualizations.
Read more »Working with images in Power BI Desktop reports
April 6, 2020Introduction
In the article Web URL configuration in a Power BI Desktop report, we explored a different method to use Web URL in a Power BI report. Images help to improve the visual appearance of a report. You can convey messages easily using these images in a report.
Read more »Scroller visual for Stock price movements in Power BI Desktop
March 31, 2020In 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 »How to use a Web data source in Power BI Desktop reports
March 30, 2020This article explores various ways to use a Web data source in Power BI Desktop reports.
Read more »