Forum Discussion
Helper IWarehouse forced migration concern - October Deadline
Super UserHi mpros
I’ve seen this error come up during the Datamart >> Warehouse migration. The message with UnknownErrorCode is pretty generic, but usually means the service can’t run the query against a Datamart anymore.
A couple of things to try:
- Make sure your workspace has Fabric enabled and that you are pointing the Flow to a Warehouse (not the old Datamart).
- Re-create the Gen2Flow after provisioning the Warehouse in many cases that clears the error.
- If it still fails, raise a support ticket and include the error ID you shared.
Since Datamarts are being retired in October, I’d recommend starting the migration to Warehouse now so you don’t hit a sudden stop in data consumption.
Helper IDear,
as mentioned I'm facing the pre-mentioned issue while creating "Destination to Warehouse" Gen2Flow.
I guess also it's fabric enabled, cause I have N datamarts deployed and working.
Regards
- rohit1991
Hi mpros
Thanks for clarifying. Since Fabric is enabled and your Datamarts are working fine, the issue is likely with how the Gen2 Dataflow is connecting to the Warehouse. A few quick checks:
- Make sure the Warehouse is in the same workspace as your Dataflow.
- In Dataflow settings, confirm that the destination is set to Warehouse (sometimes it defaults to Lakehouse).
- Check that your workspace role is Contributor or higher, otherwise it won’t let you write.
- Try a very simple test table to see if the issue happens with all loads or just your current one.
If it still fails, it may be a current limitation with Warehouse + Gen2 Dataflows, so raising a support ticket would be the safest option.
- mpros
Hi rohit1991
- Same workspace data and and owning rights of the workspace.
- Destination is Warehouse
- Tried simple select, and still have same issue.How do I raise support ticket?
Thanks
v-veshwara-msftCommunity Support
Hi mpros ,
Thanks for confirming the checks and sharing the screenshot.
Since the error is showing only as UnknownErrorCode, it does not provide enough detail to troubleshoot further. At this point, the best option is to raise a support ticket so the Microsoft support team can investigate with the error ID you shared.
You can raise a support ticket directly from the Fabric portal by going to Help & Support (top right) --> Get Microsoft Help --> New Support request.
Please include the request ID (ab444592-4458-4d10-9370-b53d86adc13b), your workspace name, and the steps you followed when creating the Dataflow Gen2 with Warehouse as the destination.
Here is the guide to create Support ticket: How to create a Fabric and Power BI Support ticket - Power BI | Microsoft Learn
Hope this helps. Please reach out for further assistance.
Thank you.