The best Power Query and M documentation – Introducing PowerQuery.how
March 11, 2024A good documentation is essential in order to work efficiently in IT. Sometimes a software manufacturer does a good job…
Remove rows that exist in another table in Power Query – How to use an Anti-Join (Not-In-Join) for data cleansing in Power BI
April 16, 2023When you're preparing your data in Power Query, you might come to the point where you have to exclude rows…
One-step conditional value replacement in a column in Power Query
March 13, 2023When you're working a lot with Power Query, you will sooner or later have to replace values in a column,…
Loading Web Data into Power BI Service without Using a Gateway
April 10, 2022Many times, I'm creating a report in Power BI Desktop with data from a website. As an example, let's imagine…Replace data sources in Power Query with published Power BI dataset
June 11, 2021Occasionally, as a Power BI developer, you are faced with the task of replacing the data source in existing reports…Calculate ISO 8601 week in Power Query
January 9, 2021Last week we already dealt with the topic of the correct calculation of the ISO week in DAX. Since the…
Convert UNIX Timestamp to DATE or DATETIME format in Power BI
November 1, 2020If you find a date or datetime format in UNIX format, the first thing you wonder is what it is…My frequently used Power BI snippets
October 6, 2020In my first blog post, I briefly mentioned that my digital notebook - in the form of OneNote - is…Combine multiple tables with UNION / UNION ALL in SQL Server, APPEND in Power Query or UNION in DAX
October 2, 2020If you want to combine several tables, you have to ask yourself whether you should do this already in the…Load files with changing names from folders with changing names into Power Query
September 28, 2020What at first sounds complicated and not very useful, can be found in reality from time to time. Recently the…