Tag: SQL Server

Using DAX To Load Data From SSAS To Power BI

Using DAX To Load Data From SSAS To Power BI - Enterprise DNA

In this tutorial, you’ll learn about the queueing capability of DAX. You’ll learn how to use it to load data from the SQL Server Analysis Services (SSAS) to Power BI. In this example, a SQL Server data model has already been created. It contains tables for the Customer, Dates, Products, and Sales data. You’ll learn

Continue reading

How Data Segmentation Works In Power BI

An Overview on Data Segmentation In Power BI - Enterprise DNA

In this tutorial, you’ll learn about the basic concepts of data segmentation in Power BI and SSAS. Specifically, you’ll learn about the operational definition of data segmentation and its advantages. An Overview On Data Segmentation When you import data in Power BI, you need to click the Close & Apply option. In the case of

Continue reading

Subquery In SQL For Power BI Users

Subquery In SQL For Power BI Users - Enterprise DNA

In this tutorial, we’ll learn and understand how we can utilize a subquery in SQL. A subquery is a query within another query. We can also call it a nested query within a larger query. It must be enclosed with a bracket and mostly used in a WHERE clause. We can utilize subqueries in SQL

Continue reading

Create Power BI Report To SQL Server Using R Script

Today, I will talk about a cool feature of Power BI where you can fix your data from the Power BI desktop or Power BI web service to SQL server. We encountered a situation where we had to pull data from Power BI desktop to SQL server and use R script. In order to demonstrate

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