Forum Discussion
Encountering an issue while importing data from Azure Cost Management into a Lakehouse
Hi fkc38 ,
Thanks for sharing the details. From what you’ve described, it looks like the failure happens specifically during ingestion into the Fabric Lakehouse table. The error message:
Azure Usage details_WriteToDataDestination ... Error code: 999999
suggests the problem occurs at the write-to-destination stage rather than during data retrieval. A few things to try include re-authenticating the data source by refreshing the Azure Cost Management connection in your Dataflow settings, as expired tokens or permissions can cause failures. You might also test smaller data loads by reducing the “Number of Months” parameter or narrowing the scope; if these succeed, the issue could be related to payload size limits during Lakehouse ingestion.Other helpful steps are creating a new Lakehouse or writing to a Warehouse to see if the issue is tied to your current schema or partitions, validating the API externally via Power BI Desktop or Postman, and checking that your Lakehouse is within capacity and quota limits. If the table schema was manually modified, try restoring or recreating the destination table. If none of these resolve the problem, submitting a Microsoft support ticket with the Request ID or Tracking ID from the failed refresh is recommended, as the generic error code may reflect recent backend changes in the service.
Super UserHi fkc38,
What you’re seeing is a fairly common pattern when a previously stable connector suddenly starts failing: the ActionUserFailure and 999999 error codes are generic indicators that something changed in the service endpoint or authentication layer, not necessarily in your query. Since this began specifically after August 18, it suggests a backend update or policy change in the Azure Cost Management API.
Quick Things to Try
Re-authenticate the data source connection in your dataflow settings. Token expiration or changes in consent scopes often trigger these errors.
Test outside Fabric: Use Power BI Desktop or Postman with the same parameters (Enrollment Number, Scope, Number of Months) to confirm whether the API still returns data.
Check limits: The Azure Cost Management API enforces throttling and row size limits. If your requested time window expanded or data volume grew, try a smaller “Number of Months” value to see if the query succeeds.
If you found this helpful, consider giving some Kudos. If I answered your question or solved your problem, mark this post as the solution.
Thank you for the reply. But I am facing this issue in Fabric Lakehouse while ingesting the data in to the table.
