Power Query

Power Query or SQL Server? Which, when and why

  • Article

When it comes to developing a Power BI report, we can use it for accessing data, transforming the data, and turning the data into information using visuals. With no doubt Power BI can do the job from beginning to end. Now, this is not the only, nor necessarily the best, tool for all the steps […]

4 (3)

2021-01-25

5,207 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,043 reads

Blogs

The Diverse Data Platform–Dativerse.io

By

The other day I got a note from Ben Weissman the other day that...

Extended Events and Azure SQL Database

By

Knowledge of how your system behaves is vital to better control, maintain, and grow...

Daily Coping 19 Apr 2021

By

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

Read the latest Blogs

Forums

Replication - not all columns are updating

By screenshot

I've set up replication but I'm having difficulties in my testing. I've changed 3...

The Security of Source Code

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Security of Source Code

Running SSIS in ADF

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Running SSIS in ADF

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers