Power Query

Suche

Finding errors in Dataflows or PowerQuery

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

121 Ansichten0 Kommentare

How to open .ods files in Power BI / Power Query

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

301 Ansichten1 Kommentar

New ways to check if queries fold in Power Query

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

273 Ansichten0 Kommentare

Allocating amounts using lists in Power Query

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

40 Ansichten1 Kommentar

Dataflows gets around the 3,000 cell enter data limit in Power BI

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

187 Ansichten0 Kommentare

How to avoid having to use a personal gateway for web data sources (html page or table) in Power BI

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

2.133 Ansichten8 Kommentare

Changing data types that do not break query-folding in Power Query / Power BI

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

1.392 Ansichten0 Kommentare

Creating a custom fiscal calendar in Power BI

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

708 Ansichten0 Kommentare