无法从PowerBI或其他桌面应用程序连接到Azure SQL数据库,但我可以从Azure Data Studio连接 [英] Cannot connect to Azure SQL Database from PowerBI or other desktop apps, but I can connect from Azure Data Studio
问题描述
无法从PowerBI或其他桌面应用程序连接到Azure SQL数据库,但我可以从Azure Data Studio连接。
Cannot connect to Azure SQL Database from PowerBI or other desktop apps, but I can connect from Azure Data Studio.
Azure SQL数据库防火墙设置为0.0.0.0到255.255.255.255
Azure SQL Database firewall is set as 0.0.0.0 to 255.255.255.255
允许访问azure服务
Allow access to azure services is on
我从桌面Azure Data Studio输入数据库中的表和数据
I have tables and data in the database entered from desktop Azure Data Studio
我在3台不同的机器上安装了PowerBI,它说无法连接到天蓝色数据库服务器
I have installed PowerBI on 3 different machines and it says it cannot connect to the azure db server
我无法看到PowerApps的azure数据库
I cannot see the azure database from PowerApps either
PowerBI - >获取数据 - > Azure SQL Server数据库 - >
PowerBI -> Get Data -> Azure SQL Server Database ->
 服务器:  servername.database.windows.net
Server: servername.database.windows.net
 数据库: 有或没有dbnamehere的同样错误
Database: same error with or without dbnamehere
 数据连接模式: DirectQuery
Data Connectivity Mode: DirectQuery
 高级选项 - >以分钟为单位的超时:30,包括关系列
Advanced Options -> Timeout in minutes: 30, Include relationship columns
推荐答案
您能否发布错误或截图我们要进一步排查。
Could you please post the error or screenshot for us to troubleshoot further.
这篇关于无法从PowerBI或其他桌面应用程序连接到Azure SQL数据库,但我可以从Azure Data Studio连接的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!