Tag: SQL for Power BI

SQL WHERE Clause For Filtering Data

In this tutorial, we’ll discuss what the SQL WHERE clause is and how to use it. We’ll also talk about multiple conditions by using AND and OR operators.  The SQL WHERE clause is for filtering data or records. It’s used to create a condition to extract only the necessary records needed.  Aside from using the

Continue reading

SQL SELECT Statement: An Introduction

Introduction To SQL SELECT Statement

In this tutorial, we’ll learn about extracting data from databases and different tables. The SQL statement that we’re going to use is the SQL SELECT statement. The SELECT statement is used for fetching data from our database.   Syntax For The SQL SELECT Statement To select all columns or fields from a table, we need to

Continue reading

Query Folding And Connecting To SQL Server

Query Folding And Connecting To SQL Server

In this tutorial, we’ll learn how to connect to SQL server. We’ll also discuss how query folding works in Power Query and how we can run SQL commands in Power BI. Inside Power Query, we can extract and manipulate data from various sources. With query folding, we can offload data transformations to the source instead

Continue reading

SQL Server Download And Installation

SQL Server Download and Installation

In this blog, we’ll talk about preparing the environment by installing SQL Server (Developer Edition), and SSMS (SQL Server Management Studio). We’ll also have a little practice by downloading and restoring AdventureWorks databases (Practice Databases). SQL Server is system from Microsoft for managing databases. It’s completely free and a full-featured DBMS for developers. After installing

Continue reading