Power Query - Optimization with templates and dataflows
As we've seen so far, there are many ways to optimize the loading of our data and our working methods. This time, let's see how we can optimize report loading.
-
-
Power Query - Optimization with functions and variables
Still with the idea of optimizing our data acquisition, there are also methods for optimizing the way we work. Let's take a look at how you can become a more efficient editor using functions and variables.
-
Power Query - Optimize with fewer steps
In the wonderful world of data acquisition with Power Query, it can happen that certain queries take longer to execute. There are several ways to optimize queries in Power Query. Let's take a look at some of them.
-
Power Query - OData, Web and VSTS
Sometimes, our data sources don't come from databases, but rather from web services. Here we present four Power Query connectors to achieve this.
-
Power Query - Data grouping
In order to keep track of all this, it is often necessary to connect to different data sources, which are not always compatible with each other. Let's see how to overcome this problem.
