Understanding of Power Query


Power Query is a data transformation and cleaning tool developed by Microsoft, which is available as an add-in for Microsoft Excel and as part of the Microsoft Power BI suite. Power Query allows users to import, transform, and cleanse data from various sources in order to create clean, organized data tables that can be used for analysis and reporting.

With Power Query, users can connect to a wide range of data sources, including databases, spreadsheets, text files, and web pages. Once connected, Power Query provides a range of tools for transforming the data, such as filtering, sorting, grouping, pivoting, and merging. Users can also create custom calculations and transformations using the M language, which is the scripting language used by Power Query.

Power Query has a user-friendly interface that allows users to easily navigate through the various data transformation steps. It also provides a preview of the transformed data, allowing users to see the changes in real-time.

Power Query is particularly useful when working with messy, unorganized data or large data sets that require cleaning and transformation. It can also help automate repetitive data cleaning tasks, saving time and reducing errors. Additionally, Power Query provides a way to merge data from different sources and format it in a way that is suitable for analysis or visualization using Excel or Power BI.

Overall, Power Query is a powerful data transformation and cleaning tool that can help users import, transform, and cleanse data from various sources in order to create clean, organized data tables that can be used for analysis and reporting.


These are Aspects related to Power Platform like 

Power Apps 

Power Query 

Power Automate 

Power BI



Comments

Post a Comment

Popular posts from this blog

RichTextBox Field in power apps as Sharepoint online defalut forms.

Let's say you have some rich textbox columns in Sharepoint online, when we create a default canvas app the columns will show as a plain multiline text field. when we view this content in view mode the content of the Richtext field with HTML added to it.  So to correct this remove the multiline field and add a rich textbox  To replace a multiline text field with a Rich Text Box in Power Apps, you can follow these steps: Delete the multiline text field from the screen by selecting it and pressing the "Delete" key. Insert a new Rich Text Box control onto the screen by selecting it from the "Insert" menu. In the right-hand pane, under the "Data" tab, Change some properties as Default is set to Parent.default and DisplayMode as Parent.DisplayMode. These fields are needed to be set as the value sync automatically with the parent.  Configure the appearance of the Rich Text Box control, such as the font size and color, by selecting the control and using the fo
Read more

Difference between Less and CSS ?

Many of you may be familiar with the concepts of CSS. In CSS we can not write loops ,logic or many other programming constructs such if-else etc.Thus we can say css is a static language. On the other hand LESS or (SCSS) are CSS pre-processors. You can think of it as CSS with programming constructs, which help you in making your code modular and reusable. One possible use case is you can develop a theme system with LESS, its very easy by using variables for colors etc and changing the variable values to create a new theme for your webpage. Take a look at this example taken from Getting started | Less.js. @base: #f938ab; .box-shadow(@style, @c) when (iscolor(@c)) { -webkit-box-shadow: @style @c; box-shadow: @style @c; } .box-shadow(@style, @alpha: 50%) when (isnumber(@alpha)) { .box-shadow(@style, rgba(0, 0, 0, @alpha)); } .box { color: saturate(@base, 5%); border-color: lighten(@base, 30%); div { .box-shadow(0 0 5px, 30%) } } Compiles to .box { color
Read more