Forum Discussion

Resolver I

5 years ago

Solved

Difference between Synapse connector and SQL Database connector

Hi Everyone,

I am able to get the data in Power BI from Synapse by using both Synapse connector and SQL Database connector, so what is the difference??

amitchandak
5 years ago
@Pulkit, Synapse can store data stored in a data lake or in tables. which can be queried using SQL and many other languages.

For Synapse better use the Synapse connector. Synapse is the advancement of Azure SQL DW, in simple words. But it's much more than that,

Greg_Deckler
Community Champion
5 years ago
Pulkit Synapse is the SQL Data Warehouse version of SQL Server. So, it's all SQL but if your data is actually in Synapse, probably best to use that connector.
amitchandak
Super User
5 years ago
@Pulkit, Synapse can store data stored in a data lake or in tables. which can be queried using SQL and many other languages.

For Synapse better use the Synapse connector. Synapse is the advancement of Azure SQL DW, in simple words. But it's much more than that,
v-xicai
Community Support
5 years ago
Hi Pulkit ,

Do the suggestions from engineers make sense? If so, kindly mark the proper reply as a solution to help others having the similar issue and close the case. If not, let me know and I'll try to help you further.

Best regards

Amy