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

4 Replies

v-danhe-msft
Microsoft Employee
7 years ago
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-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

Related content