Tag: Power BI Desktop

Overview Of The Query Editor User Interface In Power BI

Overview Of The Query Editor User Interface In Power BI - Enterprise DNA

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

Continue reading

Create Power BI Report To SQL Server Using R Script

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

Continue reading

Power BI What If Parameter For Data Models

Scenario tables 'what if' parameters

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

Continue reading

Appending Several Sheets In Excel To Power BI

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

Continue reading

Python In Power BI: How To Install And Set Up

Python In Power BI: How To Install And Set Up

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

Continue reading