Connect to Azure SQL DW

[SivaMani]

I don't see any option to connect Azure SQL DW however it shows Download Desktop. Please assist me.

[v-danhe-msft]

Hi @SivaMani,

Based on my research, you could connect the SQL Data Warehouse with the Open in Power BI button within the Azure Preview Portal. 

Reference:

https://pbiwebprod-docs.azurewebsites.net/en-us/documentation/powerbi-azure-sql-data-warehouse-with-...

Regards,

Daniel He

[SivaMani]

@v-danhe-msft,

Thanks for the reply. It doesn't work.

It redirects to Get Data page and Desktop starts downloading automatically when I click Open in Power BI option.

[v-danhe-msft · Accepted solution]

Hi @SivaMani,

Based on my research, if you want to get data from Power BI service, due to The direct connector for Azure SQL Data Warehouse in the Power BI service is now deprecated, I am afraid you could not achieve this feature, I suggest you to get data from desktop and publishe to the service.

https://docs.microsoft.com/en-us/power-bi/service-azure-sql-data-warehouse-with-direct-connect#using...

Regards,

Daniel He

[SivaMani]

Thank you for the confirmation.