All these three things are necessary to get a properly typed numeric column in your Power Query query – if you vary from this too much then folding won’t happen. It’s also possible to use this ...

Technical documentation for Microsoft SQL Server, tools such as SQL Server Management Studio (SSMS) , SQL Server Data Tools (SSDT) etc. - MicrosoftDocs/sql-docs ...

This post adds one more useful detail: how to preserve the original data types of the columns in your query when using this technique with SQL Server-related sources. Consider the DimDate table in the ...

That being the case, you’ll need a couple additional columns of datetime2 data type, the VALIDFROM and VALIDTO columns, which tells SQL Server which snapshot of the temporal table to use when querying ...