Solved: Can Fabric data warehouse be the external data sou...

yeungcase · ‎07-05-2024

Hi All,

I am wondering whether I could create an external table in Azure SQL database which references Fabric data warehouse data.

Appreciate for any advice.

NandanHegde · ‎07-05-2024

Based on my understanding, that wont be possible.

Reason: extrenal table /elastic queries within Azure SQL database only support SQL authentication and no AD based authentication.

And fabric warehouse doesnt support SQL accounts.

----------------------------------------------------------------------------------------------
Nandan Hegde (MSFT Data MVP)
LinkedIn Profile : www.linkedin.com/in/nandan-hegde-4a195a66
GitHUB Profile : https://github.com/NandanHegde15
Twitter Profile : @nandan_hegde15
MSFT MVP Profile : https://mvp.microsoft.com/en-US/MVP/profile/8977819f-95fb-ed11-8f6d-000d3a560942
Topmate : https://topmate.io/nandan_hegde
Blog :https://datasharkx.wordpress.com

View solution in original post

NandanHegde · ‎07-05-2024

Based on my understanding, that wont be possible.

Reason: extrenal table /elastic queries within Azure SQL database only support SQL authentication and no AD based authentication.

And fabric warehouse doesnt support SQL accounts.

----------------------------------------------------------------------------------------------
Nandan Hegde (MSFT Data MVP)
LinkedIn Profile : www.linkedin.com/in/nandan-hegde-4a195a66
GitHUB Profile : https://github.com/NandanHegde15
Twitter Profile : @nandan_hegde15
MSFT MVP Profile : https://mvp.microsoft.com/en-US/MVP/profile/8977819f-95fb-ed11-8f6d-000d3a560942
Topmate : https://topmate.io/nandan_hegde
Blog :https://datasharkx.wordpress.com

Can Fabric data warehouse be the external data source for Azure SQL database?

Helpful resources

Fabric Community Update - July 2025

Party with Power BI’s own Guy in a Cube

Can Fabric data warehouse be the external data source for Azure SQL database?

Helpful resources

Fabric Community Update - July 2025