We show how you can easily search a Power BI semantic model's M code in just a few clicks using an external tool.

In this blog post we can see how we can easily connect Power BI to the Jira REST API to retrieve data.

When working with decimals and integers from Snowflake in Power Query, you need to watch out for data type conversion.

How to remove unused columns and measures using Power BI external tool Measure Killer

This article outlines how you can find errors quickly in Dataflows or PowerQuery using a small M script.

This blog post shows how to import .ods files on the web natively into Power Query / Power BI.

This article outlines an approach besides "View Native Query" to check if query folding is happening in Power BI / Power Query or not

We will show you how to create dates between a start and an end date using the list operator in Power Query. This can be handy as well for a

This blog posts shows that in Power BI Dataflows you can get around the 3,000 cell paste limit (Enter Data) in Power BI Desktop

When you import publicly available data into your report you will most likely use the web connector in Power Query. This might lead to...

There are some data type changes that can be performed without breaking query-folding. We tested this with SQL Server 2016 as a data source

Transforming your custom fiscal dates to number format and then generating a list of values between them will give us all dates in between.