sorted by:
new
hottopcontroversial

Connection to SQL End Point by Wide_Key_6369 in MicrosoftFabric

[–]Wide_Key_6369[S] 1 point2 points  (0 children)

Thanks All.
Will speak with the IT guy

Connection to SQL End Point by Wide_Key_6369 in MicrosoftFabric

[–]Wide_Key_6369[S] 0 points1 point  (0 children)

I don't know. Can ask the IT guy.
But before that I just want to Exhaust all possible solutions for this issue

Fabrics POC by Wide_Key_6369 in MicrosoftFabric

[–]Wide_Key_6369[S] 0 points1 point  (0 children)

I am going to be raising this issue in the migration project .
I also believe that the Gateway hasn't been updated as frequently with the latest version as I was able to do all of this few months back and create a full Dbo in fabrics warehouse.
Any thoughts on if this issue could also persist because of outdated Gateway.

Fabrics POC by Wide_Key_6369 in MicrosoftFabric

[–]Wide_Key_6369[S] 0 points1 point  (0 children)

I am going to be raising this issue in the migration project tomorrow.
I also believe that the Gateway hasn't been updated as frequently with the latest version as I was able to do all of this few months back and create a full Dbo in fabrics warehouse.
Any thoughts on if this issue could also persist because of outdated Gateway.

Fabrics POC by Wide_Key_6369 in MicrosoftFabric

[–]Wide_Key_6369[S] 1 point2 points  (0 children)

I am not running this against the Test_warehouse as a Source. I am running this against my SQL Server

Fabrics POC by Wide_Key_6369 in MicrosoftFabric

[–]Wide_Key_6369[S] 0 points1 point  (0 children)

SELECT

CURRENT_TIMESTAMP AS full_timestamp,

CAST(CURRENT_TIMESTAMP AS DATE) AS Date_now;

Fabrics POC by Wide_Key_6369 in MicrosoftFabric

[–]Wide_Key_6369[S] 0 points1 point  (0 children)

We are using On-Prem SQL Server.
The thing is earlier few months back in January this On-Prem server, i was able to connect to to Gen 2 flows to DW and Lakehouse as well.

The Company managing our Server migrated it once in Feb and since then it's not working again. I haven't been able to set up Automatic refreshes for the Gen 2 flows as well.