Forum Discussion

mpros's avatar
mpros
Icon for Helper I rankHelper I
1 year ago

Warehouse forced migration concern - October Deadline

Dears, as we approach the deadline on October of Datamarts (that are still working very well), I tried creating Warehouse + Gen2Flow with simple logic & queries, resulting in the folllowing error: ...
Need Help
rohit1991's avatar
rohit1991
Icon for Super User rankSuper User
1 year ago

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's avatar
mpros
Icon for Helper I rankHelper I
1 year ago

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-msft's avatar
    v-veshwara-msft
    Icon for Community Support rankCommunity Support
    1 year ago

    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.

    • v-veshwara-msft's avatar
      v-veshwara-msft
      Icon for Community Support rankCommunity Support
      1 year ago

      Hi mpros ,

      Just checking in to see if your issue is resolved.
      Otherwise, feel free to reach out for further assistance.

      Additionally, could you please confirm whether the issue has been addressed through the support ticket with Microsoft?

      If the issue is now resolved, we’d greatly appreciate it if you could share any key insights or the resolution here for the benefit of the wider community.

      Thank you.

      • mpros's avatar
        mpros
        Icon for Helper I rankHelper I
        1 year ago

        Hi v-veshwara-msft ,
        currently contacted Microsoft and opened a ticket. What is curious is that EXCEL import is working both for Lakehouse and DW with GEN2 flows while e.g. using Oracle or Snowflake connectors/ds the flow is stopping.
        Regards,
        Marco