Introduction

Microsoft Fabric offers with the Data Explorer a powerful tool to visualize, analyze and explore query results. It offers an intuitive interface to create visualizations and filters. In this tutorial, we will explain step-by-step how to visualize the results of a T-SQL query using the Data Explorer in Microsoft Fabric.

Goal

The results of a T-SQL query should be explored with visualizations.

Step 1: Open Data Warehouse Experience

We have already signed in into Fabric and opened the Data Warehouse Experience. We have selected the workspace "dlnerds_workspace".

Here you can see the Data Warehouse Experience.

Step 2: Open Data Warehouse Explorer

Open the warehouse from which you want to query data. We open the warehouse "dlnerds_warehouse".

Step 3: Open SQL Query

Open the SQL query that you want to save as view. We have already created the SQL query "dlnerds_select_student". If you want to know how to create a SQL query check out the following post:

How to query Data from a Fabric Warehouse with T-SQL
Introduction In this tutorial, we will explain step-by-step how to query data from a Fabric warehouse using T-SQL. Goal Data should be queried from a table in the warehouse with T-SQL. Data We consider the table student that is stored in the warehouse “dlnerds_warehouse”. Step 1: Open Data Warehouse

You can find all your SQL queries on the left-hand side under "Queries". We open the SQL query "dlnerds_select_student".

Step 4: Run SQL Query

Click on "Run" to execute the query.

Once the query has been executed, the results appear below in the Results section.

Step 5: Open Data Explorer

Now, let's open the data explorer. In order to do this, select the text of the SQL statement and click on "Explore this data (preview)".

The data explorer opens.

Step 6: Create Exploration

Now, you can create visualizations based on the query result. In our example, we want to visualize how many students are born in each year. We want to visualize the data with a vertical bar chart.

You can view this post with the tier: Academy Membership

Join academy now to read the post and get access to the full library of premium posts for academy members only.

Join Academy Already have an account? Sign In