After several years using Power Bi Desktop with many users I see that a bad practices are still implemented. At first I thought it was adjusted to the tool being new or inexperienced users. However, I'm thinking the reason is because of the lack of content about Power Query.
What I'm talking about is the bad habit of generating an enormous number of steps in the query editor to clean up data sources. Some time ago I found a short video of an Indian generating tips for the reduction of steps in Power Query which led me to think "I should generate content from this too".
This article will show some daily examples of Power Query to reduce the steps of our queries
This can answer questions like - How many of our employees didn't participate in a conference. A table contains the names of persons who enrolled to attend a conference. Another table contains the names of participants of the conference from different organizations. We need to find from our organization who all didn't attend the conference.
It just got easier to build multi-language reports for Power BI. Join us for the January session of Power BI Dev Camp and learn about new enhancements to Power BI which make it much easier to add support for secondary languages. We'll review what those changes are and we'll teach campers an approach for creating a reliable end-to-end process for extending Power BI reports to with multi-language capabilities.
Query Folding are fundamental for an efficient ETL and while working with Power Query Editor you must push the steps that breaks Query Folding to the end. Or do you… If curious, please continue reading...
This article is a follow-up to the first article where we created a visual from scratch. The approach that we used was very straightforward, we directly used the data interfaces without using any typing. In this article, we will add typed data interfaces.
This article is the first in a series. In these articles, we will predict occasion car prices (of Mitsibutsi Outlanders in the Netherlands). When you are able to predict car prices it helps to understand if a car has a relatively high or low price. Therefore, it supports decision-making when buying a car.