Feb 16 · 2 min read · Question 1: Find the source of data based on below requirement and fetch them into Power QueryQuestion 2: Find the source “public data” regarding the amount of car sales in the local market. Question 1 answer : https://web.archive.org/web/2025112111...
Join discussionAug 12, 2025 · 4 min read · Starting off with Power Query. What is a Power Query? Sounds complicated. Let me explain. 💡 Power Query is an add-on feature available within Microsoft Excel & Power BI that helps us to collect, clean and organize data from different sources like d...
Join discussionAug 6, 2025 · 8 min read · Introduction to Data Modeling What is a Data Model? A data model is the foundation of your Power BI report. It defines how data tables are connected and how they interact with each other. Think of it like a map that tells Power BI how to find and rel...
Join discussionAug 6, 2025 · 9 min read · What is Power Query? Power Query is a powerful data connection and transformation tool available in Microsoft Excel, Power BI, and other Microsoft applications. It allows users to extract, transform, and load (ETL) data from various sources into a fo...
Join discussionMar 20, 2025 · 2 min read · Dynamic queries let you adapt your data transformations on a whim without having to manually edit each step in the transformation that would be affected by the change. This can be done using parameters. What are Parameters in M Code? Parameters are v...
Join discussion
Mar 20, 2025 · 2 min read · If you’ve been using Power BI for a while but are new to M code, then you might have come across something called parameters which may seem similar to slicers from Power BI dashboard design tools. They do have some overlapping similarity but they fun...
Join discussion
Dec 19, 2024 · 3 min read · In the previous articles in the Excel series, we looked at the most basic features and tools available in Excel for data analysis. We looked at functions, pivot tables and pivot charts, data formatting techniques and charts. I hope you managed to pra...
Join discussion
May 27, 2023 · 4 min read · Hi there, welcome to my blog on Mastering Custom Columns in Power Query. In this post, I will show you how to unleash the power of data transformation by creating custom columns that can perform complex calculations, manipulate text, or extract infor...
Join discussion
Aug 22, 2020 · 2 min read · Privacy Levels Privacy Levels is set to Combine data according to your Privacy Level settings for each source by default, which means that Privacy Levels are enforced. Combine data according to your Privacy Level settings for each source (on, and th...
Join discussionJun 22, 2020 · 1 min read · You may already know that there is an existing connector to your on-premise Active Directory Get Data > Active Directory But what if you only need to get a list of users from a specific security group? Simply use the Power Query script below and cha...
Join discussion