Forum Discussion

MarkTeviotdale's avatar
MarkTeviotdale
Frequent Visitor
1 year ago
Solved

TicksToDateTime Not Working

We are currently connected to Cosmos DB Databases with Table API using a SQL connector in PowerBI   Everything has been working just fine for a number of years now,  but overnight we ran into an is...
Need Help
  • MarkTeviotdale's avatar
    MarkTeviotdale
    1 year ago

    Thanks Anonymous for your message. 

     

    We have a ticket in with Azure and the issue appears to be on the Azure Cosmos side, the current workaround at the moment is to add a ltrim example below: 

     

    add ltrim for leading zeros

    SELECT TicksToDateTime(StringToNumber(ltrim("00638435451214931790", "0")) - 621355968000070000)

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi MarkTeviotdale ,

Can you please share some more detail information about this issue and error messages? They should help us clarify your scenario and test to troubleshoot.

How to Get Your Question Answered Quickly  

In addition, have you check on the data source to confirm if this issue only appeared on power bi side?
If that is the case, I'd like to suggest you check on the recently updated if anything change applied to the api interface.

Regards,

Xiaoxin Sheng

  • MarkTeviotdale's avatar
    MarkTeviotdale
    Frequent Visitor
    1 year ago

    Thanks Anonymous for your message. 

     

    We have a ticket in with Azure and the issue appears to be on the Azure Cosmos side, the current workaround at the moment is to add a ltrim example below: 

     

    add ltrim for leading zeros

    SELECT TicksToDateTime(StringToNumber(ltrim("00638435451214931790", "0")) - 621355968000070000)