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 

 

Thanks for using Microsoft Fabric Community.

Apologies for the inconvenience that you are facing here.

This seems to be an intermittent issue. Can you please try running the Dataflow Gen2 after a day or try to create a new Dataflow Gen2 and execute the scenario. If still the issue persists please do let us know.

I tried to repro the scenario and didn't find any difficulty in accessing the data destination as Lakehouse. Please find the screenshots for reference.

 

 

I hope this information helps. Please let me know if you have any further questions.

 

Thanks.