fbpx

Category

Tutorials

Power BI Data Sources and Power BI Services

Power BI Data Sources. Microsoft Power BI is a cloud-based business analytics tool. Power BI is available in the desktop version and services version. It is the best visualization tool and can handle even the most critical business data. It helps in sharing and evaluating the data and gets connected to all the data sources...
Read More

Power BI Components and Building Blocks of Power BI

Power BI is a Data Analysis and Visualization tool for BI users which helps them in performing analysis, data modelling and preparing reports from a wide range of data acquired from the data source. Need to know, find out What is Power BI. Building Blocks of Power BI The building block of Power BI include...
Read More

Power BI vs Tableau – Comparing Functionality, Pricing and Support

Today the world is more visual than ever before, Power BI and Tableau are the leaders holding a maximum market share of this domain. Power BI and Tableau are the two best software when it comes to Data Visualization. Although they both are quite similar in functionalities, as they both are needed for data visualization,...
Read More

5 Steps to Create your first Power BI Dashboard | Power BI Dashboard

A Power BI dashboard is usually known as a canvas and it can have only one page to tell a story using visualizations. Since it is restricted to one page, a perfect dashboard contains only the most important fundamentals of the story. A dashboard is not only attractive but also very interactive and highly customizable. The...
Read More

Complete Power BI Tips and Tricks – Power BI Dashboard Tutorials

Learn all the Power BI Tips and Tricks. Power BI is an interactive data visualization and analytics tool for business intelligence. You can use it to pull data from a wide range of systems in the cloud and on-premises and create dashboards that track the metrics that you want to analyze, or drill in and...
Read More

Steps to Format Columns Using Power Query

Another important feature of Power Query is Format Columns. There are various formatting options available in Power Query for columns like Trim, Clean, Add Prefix, Uppercase, etc. In this example, we are going to see how to capitalize each word from the column using the formatting feature. Format Columns By Power Query Step 1: Select...
Read More

How to Navigate Query Editor Using Power Query

While using Power Query, you might’ve come across a step that reads ‘Navigation’  in Applied Steps pane and it is automatically created by Power Query. But, do you know what it is used for? Navigate Query Editor Using Power Query The code generated by this step is = Source{[Item=”Sheet1″,Kind=”Sheet”]}[Data] This is one of the ways...
Read More

How to Edit A Query Using Power Query

Power Query also allows you to edit a query that you have already generated. Let’s take an example. Suppose you have a data table as shown below. Editing A Query By Power Query This is an employee data and you have to create the post for each employee based on their experience given in the...
Read More

Delete Steps Until End By Power Query

If you want to delete some steps, you can do it in one shot. The Power Query Delete Until End feature helps to delete as many steps up to the end in one click. Delete Steps Until End By Power Query Let us understand this feature with the help of an example. Step 1: Load...
Read More

Data Type Conversion With ‘M’ Using Power Query

Data Type Conversion With ‘M’ with Power Query. Sometimes it happens that the things we want to do are not built in the user interface.  But Power Query’s programming language M has made this possible. Data Type Conversion With ‘M’ Using Power Query One of the unique functionality of M is that it takes data types very...
Read More

Use Excel’s Right Function With M To Extract Right Side Data

How to Extract Right Side Data form Excel? If we want to use Excel’s RIGHT Function, it is not possible as it is not supported in M. But we can use the RIGHT Function in M in other way using Power Query and the Text. End formula! Use Excel’s Right Function With M To Extract...
Read More

Replicating Excel’s Find Function With ‘M’ in Power Query

In the above example, you learned how to concatenate the columns using the M language. Unfortunately, not all of the Excel’s formulas can be used in M query. Replicating Excel’s Find Function With ‘M’ Using Power Query For instance, if we want to use Excel’s FIND function to find a specific character in the text,...
Read More

How to Add Conditional Column in Power Query

How to Add Conditional Column in Power Query Step-by-Step. In Power Query, there is a feature to add a new column called Conditional Column feature. You can define IF-THEN-ELSE conditions to add the conditional columns. When the conditions are fulfilled, the conditional column will automatically demonstrate the values that you have specified using IF-THEN-ELSE conditions....
Read More

Top Ways to Import Data From Text in Power Query

As you can import the data from Text/CSV, the same way you can import the data from the text file. The reason is that Power BI provides the same option to import the CSV file as well as a text file. Let us understand this with the help of below steps. Import Data From Text...
Read More

Best Ways to Import Data From CSV in Power Query

Now you know how to import data from an XML file in Power Query. But what if your data source is in the form of CSV file? There is no need to worry if you have your data inside a CSV file (Comma Separated Values). This is because it’s very easy to import data from CSV...
Read More

Top 5 Ways to Import Web Data in Power Query

The good thing with Power Query is that there are multiple ways to pull in data. Import Web Data Using Power Query One of the way is to get data from the internet by using the importing web data feature.  Let us see how we can parse a webpage and use it for Power Query....
Read More

Learn How to Filter Records Using Power Query

Filter records is a feature of Power Query that allows you to filter the data from your data table. Let’s see how to filter the records in Power Query with an example. Filter Records By Power Query Step 1: Load Data in Power Query Sometimes the data table is too huge and you do not want...
Read More

How to Unpivot Data Using Excel Power Query

Power Query allows you to extract data from any source, clean and transform the data and then load it to another sheet within the Power BI Designer canvas. The power Query is an advanced excel online function that enables you to connect, discover, refine and combine data sources to meet your data analysis needs. Unpivot...
Read More

Consolidate Multiple Excel Sheets Using Power Query

If you have multiple Excel worksheets that are in the same format and their underlying differences are their values and dates (e.g. January Sales List, February Sales List, March Sales-List, etc), then we can easily consolidate all the worksheets into one. The advanced excel function like Power Query will help you to consolidate multiple excel...
Read More

Consolidate Multiple Excel Workbooks in Power Query

The limitation of Excel of consolidating multiple Excel workbooks into one has overcome by Power Query.  Power Query can do this consolidation task in a couple of minutes. This is explained below within a few easy steps. Consolidate Multiple Excel Workbooks By Power Query Step 1: Open Excel Workbook from Folder Suppose you have an Excel...
Read More
1 6 7 8 9 10 14