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 ...

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 ...