在 Azure 机器上连接 Power BI 企业网关时出错 [英] error connecting Power BI enterprise gateway on an azure machine

问题描述

我使用 Image SQL Server Data Center for SQL Server 2014 在 Azure 上创建了一个虚拟机，并在该机器上创建了一些 SSAS 多维数据集.我可以从管理工作室访问多维数据集.我想从 Power Bi 访问这些多维数据集.我在那台机器上安装了 Power Bi 网关，并使用实时连接方法连接了多维数据集.我进一步安装了 Power Bi Enterprise 网关，以便将我的多维数据集刷新到 Power BI 云.现在，当我尝试使用 PBI 网关连接到 Azure 机器上的 SSAS 时，我无法连接，它给了我错误目前没有可用于服务登录请求的登录服务器".另一方面，当我尝试从 PBE 网关连接到同一台机器上的 SQL Server 数据库引擎时，我可以毫无问题地连接.天蓝色机器还不是域的一部分，这可能是我从 Power BI 网关连接到 SSAS 实例时出错的原因.

I have created a virtual machine on Azure using Image SQL Server Data Center for SQL Server 2014, and created some SSAS cubes on that machine. I am able to access cubes from management studio. I want to access those cubes from Power Bi. I have installed Power Bi gateway on that machine, and connected cubes using live connect method. I further installed Power Bi Enterprise gateway to enable refresh of my cubes to Power BI cloud. Now when I am trying to connect to SSAS on Azure machine using PBI Gateway I am not able to connect, it gives me error "There are currently no logon servers available to service the logon request." On the other hand when I am trying to connect to SQL Server database engine on the same machine from PBE gateway, I am able to connect without any problem. The azure machine is not part of a domain yet, is this may be a reason why I am getting error connecting to SSAS instance from Power BI gateway.

推荐答案

我让这台机器成为一个活动目录域控制器，所以这台机器现在是一个活动目录的一部分.现在我可以将这台机器上的 SSAS 实例连接到 PBI Enterprise 网关，但我的问题并没有到此结束，我仍然无法刷新我从同一台机器上的 SSAS 多维数据集获取的数据集.我收到错误数据源访问错误.请联系网关管理员"

I made this machine an active directory domain controller, and so this machine is now part of an active directory. Now I am able to connect SSAS instance on this machine to PBI Enterprise gateway, but my problem did not end here, I am still not able to refresh my dataset which I have sourced from the SSAS cube on the same machine. I am getting error "Data source access error. Please contact gateway administrator"

我还向 Active Directory 添加了一个新用户，其名称与我在 Power BI 中的帐户相同.我进一步将 Active Directory 中该用户的 UPN 更改为我的 Power BI 用户的 UPN.假设我的域名是 domain，upn 是 domain.local，我在 AD 中创建的新用户是 [e-mail]，我将 UPN 更改为 [e-mail]，因为这是我在 Power BI 中的登录名.之后，我能够看到从 SSAS 多维数据集填充的数据集中的数据.

Further I added a new user to Active directory, with same name as I was having an account in Power BI. I further changed UPN of that user in Active directory to that of my Power BI User. Let say name of my domain was domain, and upn was domain.local, and new user I created in AD was [e-mail], I chnaged the UPN to [e-mail], as this was my login name in Power BI. After that I was able to see data in my datasets populated from SSAS cubes.

这篇关于在 Azure 机器上连接 Power BI 企业网关时出错的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！