Forum Discussion
Helper ICopy Data from Log Analytics into fabric
Hi Danfountain ,
Thank you for reaching out to the Microsoft fabric community forum.
The issue occurs because MFA is triggered when a service account connects to Log Analytics, which interrupts your automated daily data ingestion into Fabric. Using a personal account as a workaround isn’t recommended, as token expiration causes ongoing failures.
A more effective solution is to use an Azure App Registration (service principal) with client credentials (client ID and secret or certificate). This approach avoids MFA and is designed for automated, non-interactive scenarios. Assign the service principal the Log Analytics Reader role on the workspace and use the Azure Monitor REST API to query data securely.
In Microsoft Fabric, you can set this up with Dataflow Gen2 using the Web API connector, or create a Data Pipeline with a Copy activity to call the Log Analytics API. This allows your pipeline to run automatically on schedule.
Hope this helps. Please reach out for further assistance.
Thank you.
Hi Danfountain ,
Thank you for reaching out to the Microsoft fabric community forum.
The issue occurs because MFA is triggered when a service account connects to Log Analytics, which interrupts your automated daily data ingestion into Fabric. Using a personal account as a workaround isn’t recommended, as token expiration causes ongoing failures.
A more effective solution is to use an Azure App Registration (service principal) with client credentials (client ID and secret or certificate). This approach avoids MFA and is designed for automated, non-interactive scenarios. Assign the service principal the Log Analytics Reader role on the workspace and use the Azure Monitor REST API to query data securely.
In Microsoft Fabric, you can set this up with Dataflow Gen2 using the Web API connector, or create a Data Pipeline with a Copy activity to call the Log Analytics API. This allows your pipeline to run automatically on schedule.
Hope this helps. Please reach out for further assistance.
Thank you.
Helper IThank you for that. Marked as accepted but still have a question.
The same service account that the MFA is popping up for - doesnt have the same issue when connecting to Azure SQL servers. Why is the MFA only a problem for this and not for SQL on the same account?