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 […]

1.75 (4)

2020-07-07

5,302 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

2,684 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

2,858 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

7,989 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

12,733 reads

Blogs

Daily Coping 10 Jul 2020

By

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

Daily Coping 9 Jul 2020

By

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

Refreshing a Power BI Dataset in Azure Data Factory

By

I recently needed to ensure that a Power BI imported dataset would be refreshed...

Read the latest Blogs

Forums

Controlling Intelligent Query Processing Features

By Kathi Kellenberger

Comments posted to this topic are about the item Controlling Intelligent Query Processing Features,...

To use the same function to pass table name as a parameter

By Kenean

I have this function, but I wanted to pass a table so as to...

Create SQL Login to View only one database on server

By yogi123

Hi All, I have one task to create a login, and user need to...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers