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

13,925 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

34,133 reads

Blogs

Experimenting with RedisGraph on Docker and Windows

By

I have been experimenting a bit with graph databases, trying to learn more about...

Resources for Adding Graph Structures to Your Database at VS Live

By

Thanks to everyone who attended my talk at VS Live Las Vegas 2023 on...

Resources for Architecting Zero Downtime Deployments

By

I delivered my talk on Architecting Zero Downtime Deployments yesterday at VS Live Las...

Read the latest Blogs

Forums

dbatools - Connect-DbaInstance

By rothj

I have my SQL servers name, UserID (UID) and Password (PWD) in a table...

Extracting the string before and after the given character

By sathishkm

Hi All, I want to extract the string before and after the given characters....

BULK INSERT CSV with a fixed value for a field not in the CSV

By PS_Richard

Well, I hope the title explains what it is.  Currently, I have the following...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers