Power BI service connection to Azure dedicated pool nature ?

[Anonymous]

I want to understan how Power BI service connect to Azure Synapse dedicated pool.Is that native connection or odbc or OLDB. how can we trust the security of this connection escpically in the direct query ? and 

What is the best practice connecting power bi service to Azure dedicated pool of course in different VNET , but one Azure active directory  using gateway or connect directly

[v-rongtiep-msft]

Hi @Anonymous ,

I have found a similar post, please refer to it to see if it helps you.

Solved: Re: PowerBI and Synapse Dedicated Pool - Microsoft Power BI Community

You can use SQL Server Management Studio (SSMS) to connect to and query Synapse SQL in Azure Synapse Analytics through either serverless SQL pool or dedicated SQL pool resources . 

You can refer to the 2 links below . 

https://docs.microsoft.com/en-us/azure/synapse-analytics/sql/get-started-ssms 

https://docs.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-query... 

If I have misunderstood you meaning, please provide more details.

Best Regards

Community Support Team _ Polly

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.