Forum Discussion

gregbortolotti's avatar
gregbortolotti
Frequent Visitor
2 years ago
Solved

Dataflow gen 2 cannot write in Datawarehouse anymore

Hello everyone, I have some rawdata in a fabric datawarehouse that I would like to transform. By using a dataflow gen 2 I could get the data from that datawarehouse and create new tables inside t...
Dataflows
  • miguel's avatar
    miguel
    2 years ago

    hi!

    This appears to be a known issue on the Data Warehouse side. Whenever the warehouse is orphaned or, in other words, it doesn't have an admin / owner assigned to it it may reach some issues like this one. Its not an issue specific to Dataflow, but rather one related to the Warehouse.

     

    Here's an article that explains how to fix this issue:

    Change ownership of Fabric Warehouse - Microsoft Fabric | Microsoft Learn

     

    I believe the support team may have already shared this, but I was out on vacation last week and only getting back today.

     

    Thank you for reporting this!

gregbortolotti's avatar
gregbortolotti
Frequent Visitor
2 years ago

hi v-cboorla-msft thank you for your answer.


Unfortunately yes I am still facing this issue.
I already tried to clear cache, I also tried to use a different account with the same access, but still not working.
I am also using Microsoft Edge on daily basis.
I did try just now to refresh the browser without success either.

However I found in the "manage connections and gateways" > "connections" a connection for lakehouse and warehouse. And when I click on it there is this warning:

It doesn't give me any information, and when I try to edit credentials and put an account with access, it still keep this little warning.
So I was wondering if the problem was here.

But I created a pipeline to copy the data from a lakehouse to a warehouse and it worked, so I have no idea what the problem is.

Thank you very much for your time.

  • v-cboorla-msft's avatar
    v-cboorla-msft
    Microsoft Employee
    2 years ago

    Hi gregbortolotti 

     

    Apologies for the inconvenience and the delay in response from my end.

    If the issue still persists.

    Please reach out to our support team to gain deeper insights and explore potential solutions. It's highly recommended that you reach out to our support team. Their expertise will be invaluable in suggesting the most appropriate approach.

    Please go ahead and raise a support ticket to reach our support team:

    https://support.fabric.microsoft.com/support

    After creating a Support ticket please provide the ticket number as it would help us to track for more information.

     

    Thank you.

    • v-cboorla-msft's avatar
      v-cboorla-msft
      Microsoft Employee
      2 years ago

      Hi gregbortolotti 

       

      We haven’t heard from you on the last response and was just checking back to see if you've had a chance to submit a support ticket. If you have, a reference to the ticket number would be greatly appreciated. This will allow us to track the progress of your request and ensure you receive the most efficient support possible.

       

      Thanks.

      • gregbortolotti's avatar
        gregbortolotti
        Frequent Visitor
        2 years ago

        Hi v-cboorla-msft 
        Thank you for your message.
        Yes I created it this morning. Here is the ticket number : 2405070050000336

        Thanks,
        Best regards,

        GregB