Forum Discussion
Solved
DateTime in Azure Cosmos DB
I'm using an Azure Cosmos DB that is populated through the Azure Cosmos .NET SDK. According to the documentation, DateTimes should be stored as a serialize string in ISO_8601 format (https://docs.mic...
I was able to get a solution from the issue/idea I submitted.
let ConvertTimestamp = (ts) => #datetime(1, 1, 1, 0, 0, 0) + #duration(0, 0, 0, ts / 10000000) in ConvertTimestamp(635912639960000000)
I had submitted a similar question on the Azure Cosmos Table SDK Github page and it looks like they are purposely storing this date in an unknown format. I'm guessing they aren't going to change the format so I'm going to submit an issue to Power BI to add the ability to convert this format to DateTime. For reference:
https://github.com/Azure/azure-cosmos-table-dotnet/issues/14
I was able to get a solution from the issue/idea I submitted.
let ConvertTimestamp = (ts) => #datetime(1, 1, 1, 0, 0, 0) + #duration(0, 0, 0, ts / 10000000) in ConvertTimestamp(635912639960000000)