• Brunner_BI

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

According to Microsoft's documentation, changing a column data type will break query folding.



Not all changes in data types will break query folding




This does not have to be the case though. It depends on your data source.

I tested the following Power Query data types:

text, decimal, whole number, date and datetime.


These transformations were possible and would not break query-folding:


Decimal -> text


Whole number -> decimal

Whole number -> text


Date -> datetime

Date -> datetimezone

Date -> decimal

Date -> text


Datetime -> date

Datetime -> datetimezone

Datetime -> decimal

Datetime -> text


Text -> all transformations would break query-folding


My database was running on SQL Server 2016, other versions might behave differently.


If you have had any experience with this feel free to comment!

107 Ansichten0 Kommentare

Aktuelle Beiträge

Alle ansehen
LINKS
KONTAKT

gregor@brunner.bi

Tel: +41 76 723 2735

Neustiftgasse 31

1070 Wien

AUSTRIA

UID: ATU69643816

Privacy Policy

SOCIAL
  • LinkedIn
  • Facebook

© 2020 by BRUNNER BI