Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Microsoft SQL: Cannot open server

Não há acesso à minha base de dados do Azure no Power BI Desktop.

Inicialmente, instalei o Power BI Desktop e fiz o acesso a uma base de dados e importei algumas tabelas para teste.

Em busca de uma consulta DirectQuery e estou emitindo esta mensagem:

 

 

Detalhes: "MicrosCapturar.JPGoft SQL: Não é possivel abrir o servidor "lstranslog.com.br" chamado pelo login. O login falhou. "

 

O acesso é feito através do SQL MANAGEMENT STUDIO, ou seja, não tem problemas com acesso e senhas.

 

Status: New
Comments
v-qiuyu-msft
Community Support

Hi @Fernandamrl,

 

If the Bing Translator works, the issue is:

 

There's no access to my Azure database on Power BI Desktop.

Initially, I installed the Power BI Desktop and did access to a database and imported some tables for testing.

In search of a DirectQuery query and I am issuing this message:

Details: "Microsoft SQL: Unable to open the server " lstranslog.com.br "called by login. The login failed. "

Access is done through SQL MANAGEMENT STUDIO, which means you have no problems with access and passwords.

 

As you mentioned in SSMS, you can connect to the Azure SQL fine. In Power BI desktop, do you use the same credential to get data? 

 

Please go to the Data Source Settings, find the connection which points to this Azure SQL server, then clear it's credential. Then get data from the Azure SQL, enter the same name as you used in SSMS. 

 

q1.PNG

 

By the way, please post the issue in English so we can understand the issue better. 

 

Best Regards,
Qiuyun Yu