An Azure service that is used to collect, analyze, and act on telemetry data from Azure and on-premises environments.
Hello @steinfin - Front Door writes its logs to AzureDiagnostics, as you found, and AzureDiagnostics is not a table that supports transformations. That is the whole problem. A workspace transformation DCR only applies to tables that have transformation support, so yours is being silently ignored. Nothing in it is misconfigured, it just cannot fire against that table.
It is also why your Blob Storage rule works. Those logs land in StorageBlobLogs, which does support them. The two rows from the Azure Monitor Logs table feature support page:
StorageBlobLogs carries the DCR indicator, AzureDiagnostics does not. The data collection transformations documentation sets the rule: supported tables are "Any Azure table listed in Logs table feature support with the indicator." Front Door has no resource-specific table either, so there is nowhere else to send the data.
So for your first question: no, not through a workspace transformation DCR.
For your second question: yes, but not through the diagnostic setting alone. Point it at an event hub instead of Log Analytics, which is what the docs suggest event hubs for, "integrating with other security information and event management (SIEM) tools or external data stores". Minimize in your own consumer, then push the reduced payload into a custom table with the Logs Ingestion API. You supply the DCR there, and that DCR can carry a transformation: "You can also use the transformation to filter source data and perform any other calculations or conversions."
More moving parts, but the minimization happens before anything reaches the workspace, which is where you want it for GDPR. And you keep the FrontDoor Access Log category, so you do not lose the URL and caching detail you are collecting this for.
Help make this community better for everyone: if this answer resolved your issue, please accept it or leave an upvote. If not, share more details in a comment so we can continue the discussion and find the right solution.