Support DateTime Populated Through Azure Cosmos Table SDK

[BenKoth]

The Azure Cosmos Table SDK is storing DateTime's in some format that they aren't releasing or documenting. This makes it impossible to convert it to a DateTime in Power BI.

https://github.com/Azure/azure-cosmos-table-dotnet/issues/14

Since Power BI now supports Azure Cosmos DB as a data source I feel like there should be an option to convert this value to a DateTime from within Power BI. Other Microsoft tools like the Azure portal and the Azure Storage Explorer are converting the value into a DateTime string when displaying it.

[v-qiuyu-msft]

Hi @BenKoth, 

You can modify the Power Query like below: 

let
ConvertTimestamp = (ts) => #datetime(1, 1, 1, 0, 0, 0) + #duration(0, 0, 0, ts / 10000000)
in
ConvertTimestamp(635912639960000000)

Best Regards,
Qiuyun Yu