Power BI

Business Reasons For Implementing Power BI

  • Article

Data is stored in heterogenous environments in many organizations. Enterprise reporting for management and other departments is created using a variety of tools.  There are Excel Workbooks, SSRS Reports, Tableau Dashboards, flat files, data streams from MySQL databases, etc.  Each data extract or report is created by a BI or DB Development Team member.  Often […]

2.83 (6)

2020-07-07

6,648 reads

Create Custom Functions in Power Query

  • Article

Introduction Often at times, you may come across situations where you need to calculate a column repeatedly multiple times in the same Power BI report or across multiple reports. Although you can use the calculated columns to some extent, these are not robust and not reusable. In order to reuse the same piece of code, […]

5 (2)

2020-04-21

10,798 reads

Fetch Web Data in Power BI

  • Article

Introduction Reporting on web data has been a fascinating part of developing any dashboard or reports in Power BI. Often this data is available either free that can be consumed anonymously or by using some kind of authentication mechanism. In this article, I'm going to demonstrate how to connect to a web application from Power […]

2020-03-17

3,947 reads

Using the RANKX function in Power BI

  • Article

Introduction In this article, I'll explain the use of the RANKX function available in DAX. The RANKX is a sortation function which is capable of performing a quite complex sorting and ranking based on the groups and values available in the dataset. It returns the ranking of a particular number available in each row of […]

5 (1)

2020-03-12

12,239 reads

Month-over-Month calculation using DAX in Power BI

  • Article

Introduction Period-over-period is an analysis technique in business that measures some value in the present and compares it to the same measurement in a comparable period of time in the past. The goal is to adjust the slice of the past you are viewing, so the same amount of time has passed in the two […]

3.67 (3)

2020-01-27

42,364 reads

Blogs

Updated Pluralsight Course – Managing the Kubernetes API Server and Pods

By

My updated course “Managing the Kubernetes API Server and Pods” in now available on Pluralsight here! If...

Daily Coping 11 May 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

What do you do when technology changes? : T-SQL Tuesday #138

By

Our host for this month’s TSQL Tuesday is Andy Leonard (blog|twitter). He’d like us...

Read the latest Blogs

Forums

Copy value from one row to another if column matches

By bent

Hi there, I just don't get it. Need to update rows in same table....

Does lastBatch in sp_who2 really mean the time the user execute a SQL batch

By sqlfriend

I usually use sp_who2 see who is connected and is active in the SQL...

How to take a value hhmmss from the file

By Guvera

Hello, I have a file in this format "Vendor_ABC_Pro_20210422T205535". In this file, we have...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers