Microsoft SQL: Cannot open server

[Fernandamrl]

Não estou conseguindo acessar atraves do Power BI Desktop minha base de dados do Azure. Logo que instalei o power BI consegui acesso e importei algumas tabelas para testar. Exclui o arqui e tentei nova conexão dom directyQuery e a resposta que obtenho é: Detalhes: "Microsoft SQL: Cannot open server "lstranslog.com.br" requested by the login. The login failed." Ja tentei importar, conectar através do sql server e não consigo. Consigo acessar minha base de dados através do sql management studio. Ja desinstalei o power BI Desktop e reinstalei e não consigo acesso.

[v-xjiin-msft · Accepted solution]

Hi @Fernandamrl,

In your scenario, you are trying to connect Power BI to Azure SQL Server. However, it returns an error. Right?

First, what's the version of your Power BI Desktop? You can verify this under File -> Help -> About.

Then to troubleshoot your issue. You can try following method:

1. If you have ever connected to Azure SQL database in Power BI Desktop, I would recommend you go to “File –> Options and Settings –> Data Source Settings”, under “Global permissions”, select any old Azure SQL data source connections and click on clear permission. Then re-connect to Azure SQL database from Desktop,  also enter database name during the connection.

2. Please ensure that you have set up a firewall rule to allow Power BI Desktop to make a connection to Azure SQL.

Thanks,
Xi Jin.

[TDwivedi]

@v-xjiin-msft I'm using SQL Azure, Can you help me find some reference on how to Allow PowerBI desktop  as you mentioned.

[Fernandamrl]

Olá,

Problema solucionado!

Resolvi excluindo e recriando todas as minhas conexoes de fontes de dados e reisntalei o Power BI Desktop.

Obrigado!