DirectQuery Connection in Power BI; How does it work? Limitations and Advantages

In the last post, you learned about Import Data or Scheduled Refresh as a connection type. In this post, you’ll learn about the second type of connection named; DirectQuery. This type of connection is only supported by a limited number of data sources, and mainly targets systems with a huge amount of data. DirectQuery is ...

Read More

Connection Types in Power BI: Import Data or Scheduled Refresh; A Detailed Look Inside and Out

Power BI is one of the BI tools in the market that supports more than one type of connection. Each connection type has pros and cons. In this section, we are going to cover everything about Import Data or Scheduled Refresh type of connection. You will learn briefly how Power BI stores data into xVelociy ...

Read More

List.Accumulate Hidden Gem of Power Query List Functions in Power BI

There are a number of List transformations available in Power Query’s graphical interface. However, the number of functions in the graphical interface is very limited. In this post, I’m going to explain about a function that is really powerful and is not yet listed in the graphical interface. List.Accumulate is a function that loops through ...

Read More

Decision Tree: Power BI- Part 2

In the last Part, I have talked about the main concepts behind the Decision Tree. In this post, I will show how to use decision tree component in Power BI with the aim of Predictive analysis in the report. in next post, I will explain how to fetch the data in Power Query to get a dynamic ...

Read More

Decision Tree: Concepts- Part 1

A decision tree is one of the main approaches to machine learning. it is a really powerful tool for the aim of Prediction Descriptive analysis and feature selection In this post, I am going to show how decision tree works. In the future posts, I will show you some of the main algorithms for decision tree ...

Read More