Brunner_BI29. Jan.1 Min.New ways to check if queries fold in Power QueryThis article outlines an approach besides "View Native Query" to check if query folding is happening in Power BI / Power Query or not
Brunner_BI30. Dez. 20212 Min.Allocating amounts using lists in Power QueryWe 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
Brunner_BI14. Dez. 20211 Min.Dataflows gets around the 3,000 cell enter data limit in Power BIThis blog posts shows that in Power BI Dataflows you can get around the 3,000 cell paste limit (Enter Data) in Power BI Desktop
Brunner_BI29. Dez. 20201 Min.How to avoid having to use a personal gateway for web data sources (html page or table) in Power BIWhen you import publicly available data into your report you will most likely use the web connector in Power Query. This might lead to...
Brunner_BI17. Dez. 20201 Min.Changing data types that do not break query-folding in Power Query / Power BIThere are some data type changes that can be performed without breaking query-folding. We tested this with SQL Server 2016 as a data source
Brunner_BI15. Dez. 20201 Min.Creating a custom fiscal calendar in Power BITransforming your custom fiscal dates to number format and then generating a list of values between them will give us all dates in between.