Power Query

SQLServerCentral Article

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

10,984 reads

SQLServerCentral Article

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

29,648 reads

Blogs

The book that made me love goal-setting

By

Pete Wilkinson’s book “Unstoppable” finally made visualizations and goals make sense to me. Here's a...

Daily Coping 16 Aug 2022

By

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

SQL Server Query Tuning and Optimization by Benjamin Nevarez

By

I was recently asked to review SQL Server Query Tuning and Optimization by Benjamin...

Read the latest Blogs

Forums

#Error for calculation in a textbox

By jeannier175

I am getting the #error when trying to sum a calculated field in ssrs...

how to create index rebuild job on SQL Pas machine

By Diyas

how to create index rebuild job  and stats jobs on SQL Pas machine can...

How to use PowerShell to set secure SA passwords for bulk servers

By Vincent92

Comments posted to this topic are about the item How to use PowerShell to...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers