Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

devjen

Error to access SQL Server

Submitted by on ‎05-07-2018 09:49 PM

111.png

 

How do I access SQL Server?

 I can access this database with SSMS but I can't access with POwer BI!

 

Status: Needs Info
See more ideas labeled with:
3 Comments (3 New)
Comments
v-qiuyu-msft
Community Support
Community Support
‎05-08-2018 07:14 PM

Hi @devjen,

 

It seems that you are connecting to Azure SQL database, right? 

 

To get data from Azure SQL, we need to use Azure SQL database connector in Power BI desktop. 

 

w4.PNG

 

 

Also would you please translate the error message in English so we can understand the issue clearly. 

 

Best Regards,
Qiuyun Yu 

Vicky_Song
Impactful Individual
Impactful Individual
‎05-08-2018 07:15 PM
Status changed to: Needs Info
 
devjen
Frequent Visitor
‎05-09-2018 05:28 PM

2.png1.png3.png

 

I can't access both Azure SQL database and SQL Server database.

 

Unexpected Error

Logon failure: unknown user name or bad password.

 

I can access this server with SSMS

Why can't I access with Power BI??

Idea Statuses