Power Query

External Article

Power Query Formula Language in Power BI Desktop

  • Article

The Power Query Formula Language (PQFL) is a functional language that drives the Power BI transformations, and allows you to create mashup queries from scratch. In this article, Rob Sheldon demonstrates how to use it in Power BI Desktop to extract data from its source, filter rows, specify the columns, clean the data, and create visualisations.


2,714 reads

Technical Article

RE: DB Growth Issue

  • Reply

What version of SQL are you running.  There is a problem (bug) in 7.0 that would cause this to happen. After much effort back and forth with MS, they confirmed it a bug.It is fixed in 2K


Technical Article

RE: import .txt file with 00/00/0000 dates causing error

  • Reply

Glad it worked out for You. For data manipulation / cleaning I always use SQL. In DTS, if I use it, I put as little business logic as possible, if any. The staging table approach is very efficient and fault proof. *sql/bulkinsert/dts/bcp **SQL DirtySource ->* StageTable --cleanvalidatelogerrors-->** ProductionTable /rockmoose



Hyperconverged storage tuning tip for SQL Server


We all (should) know that running SQL Server in hyperconverged virtual environments, both on-premises...

Daily Coping 25 Nov 2022


Today’s coping tip is to connect with someone from a different generation. This tip...

Snowflake Classic UI vs Snowsight


This blog post is not about which User Interface is better, Classic or Snowsight...

Read the latest Blogs


DML Trigger Limits

By Steve Jones - SSC Editor

Comments posted to this topic are about the item DML Trigger Limits

A week in Seattle in 8 Slides at the PASS Data community Summit 2022

By Tonie Huizer

Comments posted to this topic are about the item A week in Seattle in...

Being Agile - A Success Story

By Hemandu Malhotra

Comments posted to this topic are about the item Being Agile - A Success...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers