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

2021-01-25

3,304 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

7,051 reads

Blogs

Synapse Analytics and .NET for Apache Spark Example 4 - JOINS

By

This is a bit of a longer one, a look at how to do...

Recovering Data from a Backup with SQL Data Compare

By

I had a customer recently ask about how to recover data from a backup...

Data Lakehouse defined

By

As a follow-up to my blog Data Lakehouse & Synapse, I wanted to talk...

Read the latest Blogs

Forums

Would I be able to erase the recently synchronized account?

By alejandraleo

On the off chance that you need to erase your recently adjusted account from...

Median Processing time, Average Procesisng time for created/closed date

By mnr123

  We have sharepoint as the data source and we have 2 dates created...

Live versus Stored Data

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Live versus Stored Data

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers