The Query Editor in Power BI is designed to help the user apply most of the common transformations by interacting with a set of ribbons and menus. In this tutorial, you’ll learn how the query editor is organized. Knowing your way around the user interface will help you become more efficient. The Query Editor In
Tag: Power BI Desktop
Today, I will talk about a cool feature of Power BI where you can fix your data from the Power BI desktop or Power BI web service to SQL server. We encountered a situation where we had to pull data from Power BI desktop to SQL server and use R script. In order to demonstrate
This article will briefly talk about integrating scenarios into our models. We can do that by using the Power BI What If Parameter feature. We can add this parameter to our reports as slicers or reference them on DAX expressions. Integrating a What If Parameter into our reports enables us to create scenarios or predictive
This tutorial will discuss about how to import and open an Excel file with multiple sheets to one Power BI table. This data Excel file will be used for this tutorial. The file contains 60 sheets of data with the same layout. The objective of this tutorial is to load all the Excel sheets to
This tutorial will show you the process of installing the Python programming language on your PC. You’ll learn how to use some of its tools, like the Independent Development Environment (IDE), which allows you to write codes and see visuals. You’ll also learn how to utilize the benefits of incorporating Python in Power BI. Installing