Forum Discussion

Resident Rockstar

7 years ago

Solved

Connect to Azure SQL DW

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

v-danhe-msft
7 years ago
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-the-open-in-power-bi-button

Regards,

Daniel He

Microsoft Employee

7 years ago

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-direct-connect/

Regards,

Daniel He

SivaMani
Resident Rockstar
7 years ago
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
  Microsoft Employee
  7 years ago
  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-the-open-in-power-bi-button
  
  Regards,
  
  Daniel He
  - SivaMani
    Resident Rockstar
    7 years ago
    Thank you for the confirmation.

Related content