Hello Damith Jinasena,
the Azure Log Analytics Data Collector doesn't support DCR-based tables, so your best option would be to use the Log Ingestion API or find a custom workaround to send data to DCR-based tables. Classic tables, however, should continue to work fine with the connector, as it supports the creation of these tables automatically.
Please check below document:
https://free.blessedness.top/en-us/answers/questions/1510906/azure-log-analytics-data-collector-managed-connect
What you need to do for DCR-based tables:
- Use HTTP POST calls to the Logs Ingestion API instead of the Data Collector connector.
- Ensure:
- The table name ends with
_CL.- The DCR stream name matches the table name.
- Your Logic App (or client) has the right permissions (e.g., Monitoring Metrics Publisher role).
- The DCR stream name matches the table name.
- The table name ends with
- Follow : https://free.blessedness.top/en-us/azure/azure-monitor/logs/logs-ingestion-api-overview
Please accept as answer and do a Thumbs-up to upvote this response if you are satisfied with the community help. Your upvote will be beneficial for the community users facing similar issues.