Power Query

At the end of last year two new, fairly minor, improvements were made to Excel VBA’s support for Power Query: you can now refresh and delete individual Power Query queries. These methods are …

Tabular Editor is not only a helpful tool for developing DAX. You can also use it to view & modify your Power Query M code, without ever opening Power BI desktop . Furthermore, there also exists a formatter for Power Query that can help you make your code easier to read & manage. He

Transforming multiple columns at once with reference to existing columns can leave you with very slow queries. Learn how to do this fast.

Azure Data Explorer has a data type called dynamic which can be used to hold scalar values as well as arrays and property bags; you can read about it in the docs here. For example (following on fro…

With Power Query we can get the Date and Time of the last refresh, or the date modified. This post will show you how.

Let's see how to create your own data types in Power BI! This is a follow up of Part 1, where we learned how it's done in Power Query.

My favourite – and it seems many other people’s favourite – new feature in the February 2022 Power BI Desktop release is support for more datasources (including SQL Server, Azure …

Here is how to manage that you always import all columns from the CSV file with Power Query. That is useful if file gets additional columns.

At Excel, customer focus is at the core of what we do. We appreciate your feedback on adding autocomplete to data validation dropdown lists in Excel for Windows. Your Excel Community votes ensured this was one of the next in line to release after smooth scrolling. Thank you for keeping us honest and...

In my last post I showed how to use Log Analytics data to analyse Power BI query activity. The problem with looking at a long list of queries, though, is that it can be overwhelming and it can be h…

QuerySurge’s BI Tester provides connectors for Microsoft Power BI, Tableau, Microstrategy, IBM Cognos, SAP, and Oracle OBIEE.

How can you create your own data types in Excel? Oh yes, you can do it! In this article, we'll learn how you can create data types in Power Query.

Log Analytics contains information on the dataset, report and visual that are associated with a DAX query but that information is in the form of IDs rather than names. Getting the IDs for specific …

In the first part of this series I showed how to create a Power BI DirectQuery dataset connected to Log Analytics to do near real-time monitoring of Analysis Services activity; in the second part I …

Late last year I was spending some vacation days playing with one of my favorite personal data sets[1], and I realized I needed a better date dimension. So I asked for one. A bunch of folks from th…

The Black Scholes formula returns the value of European put and call options. See how to calculate this with the M language in Power Query.

Simulate a slow data source - making refresh slow - in Power BI

Blogging about Power BI, Power Platform and other things I find interesting.

Sharing the NORM.DIST function in Power Query as a custom function here, as unlike in DAX it hasn't made it into the standard repertoire.

Why Power BI refreshes time out after two/five hours and how to work around this

In my quest to check out every last bit of obscure Power Query functionality, this week I looked into the ContextInfo option on the Sql.Database and Sql.Databases M functions. This option allows yo…

This blog post provides a close equivalent of the DAX's SWITCH function in Power Query, which addresses the SWITCH(TRUE... usage.

Learn about the Universal Data Consolidator in this guest blog post by Sameer Bhide!