Forum Discussion
Connaot connect to Azure SQL Data Warehouse
Hi, I am trying to connect an Azure Data Warehouse from PowerBI but cannot make the connection. When I try from PowerBI Desktop using Windows or Microsoft Account I got the following: We are...
niko159,
What authentication type do you use in SSMS and are you able to query the target database in SSMS? If you use SQL Server Authentication, in Power BI Desktop, you would need to use Database type authentication, and the username will be a user that is defined in your Azure SQL Data Warehouse instance.
In addition, please use the latest version of Power BI Desktop(April update).
Regards,
Lydia
Hi,
I'm using Active Directory Password to connect through SSMS.
I downloaded PowerBI desktop yesterday I then imagien that I am on the latest version.
Nicolas