Power Query Resources

Share

Related resources for Power Query

Create Fiscal Year and Aggregate using Power Query M Code10/9/2024 6:28:23 AM. In this Power Query video, I covered how to create fiscal Year and perform aggregation using Power Query M Code.
Create Calendar Table Using Power Query9/20/2024 10:55:59 AM. We’ll explore step-by-step instructions for transforming date data, implementing essential date functions, and enhancing your data analysis capabilities in Excel and Power BI. Perfect for improving yo
Power Query: Best Practices for Memory Consumption9/2/2024 10:27:37 AM. To optimize memory usage in Power Query, filter data early, minimize query steps, and utilize query folding to reduce data processed. Disable background data loading, optimize data types, use dataflow
Query Folding in Fabric Dataflow Gen2 (Power Query Online)5/30/2024 4:24:28 AM. Understanding Query Folding in Fabric Dataflow Gen2 (Power Query Online)" explores the concept of query folding within Microsoft's advanced data integration tool. Learn how query folding opti
How To Change Data Source Of Existing Report In Power BI4/4/2024 9:12:57 AM. To change the data source of an existing report in Power BI, access the report and navigate to "Edit Queries." Then, update the data source connection by modifying the query or connection se
Create a Workspace in Fabric1/15/2024 5:12:14 AM. This article explains how to create workspaces in Microsoft Fabric. In workspaces, you create collections of items such as lakehouses, warehouses, and reports.
Get IBM and Microsoft Daily and Weekly Historical Stocks Data from API11/10/2023 6:43:11 AM. Get IBM and Microsoft Daily and Weekly Historical Stocks Data from API.
Sales Data Analysis using Power Query Expressions11/3/2023 4:59:08 AM. This video shows how to analyse sales data using power query expressions.
Creating a Calendar Table in Excel Power Query and its Benefits10/20/2023 9:20:07 AM. This blog is based on Creating a Calendar Table in Excel Power Query
Calculating Sales Amount by Product Category in DAX and Power Query9/27/2023 8:58:27 AM. In this video, I demonstrated how to write the DAX formula and using the GUI in Power Query to calculate Sales Amount by Product Category.
Power BI Query Folding 9/22/2023 5:21:57 AM. Query Folding in Power BI is a performance-enhancing feature that optimizes data analysis. It pushes data transformations to the source, improving data refresh and incremental processes. Learn how it
Power BI Data Transformation Basics for Insights9/12/2023 10:29:21 AM. Power BI Power Query Basics Transforming Data for InsightsPower Query is a data transformation tool in Microsoft's Power BI suite. It connects, cleans, and shapes data from diverse sources, enabli
Power Query Features Related to Rows3/16/2023 9:46:32 AM. This article is about cleaning and transforming the data using Power BI query editor. Power Query has a large number of features that will help you clean and prepare your data for analysis. In this ar
Call Rest APIs From Power BI / Power Query7/31/2022 11:42:38 PM. Sometimes, we encounter a requirement where we need to call some sort of Rest APIs from Power BI Desktop. In this article, I will teach you a step by step procedure for calling Rest APIs from Power BI
Add Index Column In Power BI Using Power Query Editor7/30/2020 12:50:25 PM. In this article, you will learn how to add Index Column in Power BI using Power Query Editor.
Add Conditional Column In Power BI Using Power Query7/29/2020 8:55:56 AM. In this article, you will learn how to add conditional column in Power BI using Power Query.
Add A Column from Example In Power QueryEditor7/28/2020 12:04:21 AM. In this article, you will learn about PowerBI's feature of adding a column from an example in Power QueryEditor.
Removing Unnecessary Rows Using Power Query In Power BI7/19/2020 8:09:20 AM. In this article, you will learn how to remove Unnecessary Rows using Power Query in Power BI.
Power Query In Power BI7/16/2020 6:10:50 AM. In this article, you will learn about Power Query in Power BI.
Introduction to Power BI6/18/2020 1:20:15 AM. This article introduces Power BI, a Business Intelligence solution developed by Microsoft to convert data into information.
How to Add Power Query to Excel 20136/18/2020 12:37:06 AM. Power Query is one of the most powerful tools available in Power BI.
PowerQuery - Dynamically Pass Database Name as Parameter to fetch the Records from Different Datasets using Managed Parameters and Functions11/5/2019 7:38:00 AM. In this article, we will talk about how we can get the database name using Stored Procedure based on the Customer ID and pass that Database Name to another stored procedure as a Parameter to load the
Reverse Geo Coding Using Google Maps API In Power Query10/23/2019 8:04:47 AM. In this article, you will learn how to reverse Geo coding using Google Maps API in Power query.
Dealing With JSON - Using Power Query In Azure Analysis Services2/6/2019 6:08:41 AM. In this article, I’ll explain some of the mechanics of the solution, using fake data to “hide the innocent” but still offer some concrete details you can use in your own solutions.
Combine and Shape the Data Using Power BI Designer4/1/2015 3:42:54 PM. This article demonstrates how to shape and combine multiple data queries into a single data query using the Power BI Designer.
Import Data From Facebook Using Power Query in Excel6/6/2014 1:40:36 PM. This article describes how to open Facebook using Power Query in Excel and also how to get data from Facebook using Power Query.

Topics