Forum Discussion

amaaiia's avatar
amaaiia
Skilled Sharer
2 years ago
Solved

Save onprem SQL Server data into Lakehouse through Dataflow Gen2

I have the gateway installed on the machine with the SQL Server running that is not open to the internet. I have created a Dataflow Gen2 to access the data and I can see the data through Dataflow pre...
Dataflows
General Question
Need Help
  • amaaiia's avatar
    amaaiia
    2 years ago

    There is not a solution. We've had 5 extended calls with Microsoft support to solve this but they don't know why is this happening to us. Finally, we are working with new internal users created in main tenant (not guest users).

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

Hi amaaiia 

 

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others.
Otherwise, will respond back with the more details and we will try to help.

 

Thanks

amaaiia's avatar
amaaiia
Skilled Sharer
2 years ago

I still have the same issue when trying to write data into Lakehouse. Tenant owner has created an internal user for me just to continue my work, because with tenant user this error is not happening.

 

At the same time, I created a ticket for this and I'm having calls with Microsoft Support, for the moment we don't have a solution for this. As soon as we solve it I will post the solution.

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

    Hi amaaiia 

     

    If you have raised support ticket, could you please provide the ticket number here as we can keep an eye on it.

     

    Thanks