When your query returns an error, sometimes it could make sense to return an empty table instead of a simple error message. And ideally, this table has the same columns (…) Read more

Have you ever come across the case where you open your dataflow and find 2 additional steps at the end of your query? Why are Power Platform Dataflows adding steps (…) Read more

Foreword from Imke: Pat Mahoney is a very active fellow super user in the Power BI community and has a very strong interest in all things Power Query. He also (…) Read more

In a previous article I have described how to use Fuzzy merge to match misspelled data to valid categories. With the sample data at hand, all values could be matched (…) Read more

Edit 24thJune 2021: Unfortunately this method is currently not working any more. The other day I discovered a neat way to split up an existing Power BI report into a (…) Read more