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

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

19,798 reads

Blogs

About blogging

By

A friend wants to get started and write a blog, and so asked me...

Daily Coping 26 Nov 2021

By

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

Daily Coping 25 Nov 2021

By

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

Read the latest Blogs

Forums

ODBC - Pipeline component has returned HRESULT error code 0xC0208457

By yrstruly

I am trying to connect to MYSQL as a target/destination via ODBC. I am...

Trouble connecting MYSQL in SSIS

By yrstruly

I connect to MYSQL in SSIS with MYSQL data provider. I am getting the...

Which version of SQL should I use?

By curtisharrington

I see SQL as a query language, used to store and retrieve data. However,...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers