Share via

Table Transformation DCR

sjoerd timo van vliet 0 Reputation points
2024-05-11T09:11:16.8766667+00:00 
source |
    extend LocalTime = datetime_utc_to_local(TimeGenerated, 'Europe/Amsterdam')

Error occurred while compiling query in query: SemanticError:0x00000009 at 2:23 : Runtime scalar function provider not found for function: datetime_utc_to_local If the issue persists, please open a support ticket. Request id: 115af713-142e-4ba1-8331-1e7cbaed119f

Hello, I can not use this query unfortunately.

Azure Monitor
Azure Monitor
An Azure service that is used to collect, analyze, and act on telemetry data from Azure and on-premises environments.
2,860 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Silvia Wibowo 3,241 Reputation points Microsoft Employee
    2024-05-13T05:50:24.7633333+00:00

    Hi @sjoerd timo van vliet , I understand that you want to use Scalar Function: datetime_utc_to_local() in your Azure Monitor DCR.

    Unfortunately, that function is not supported. See Supported KQL features for a complete list of supported features. Only the functions listed under DateTime and TimeSpan functions can be used for date/time transformation.

    Please accept an answer if correct. Original posters help the community find answers faster by identifying the correct answer. Here is how.

    0 comments