错误蔚蓝机上连接电源BI企业网关 [英] error connecting Power BI enterprise gateway on an azure machine

问题描述

我创建了一个虚拟机上使用Azure的图像SQL Server数据中心的SQL Server 2014年，并创建了机器上的一些SSAS多维数据集。我能够从Management Studio中访问多维数据集。我想访问从电源碧这些多维数据集。我已经安装了机电源碧网关和使用实时连接方式连接的立方体。我进一步上安装Power BI企业网关，使我的立方体功率BI云刷新。现在，当我试图连接到SSAS使用PBI网关我无法连接Azure的机器上，它给我的错误目前可用于服务的登录请求没有登录服务器。在当我试图连接到SQL Server数据库引擎从PBE网关同一台机器上。另一方面，我可以没有任何问题连接。蔚蓝色的机器是不是域的一部分然而，就是这可能是为什么我收到错误连接到SSAS例如从电力BI网关的一个原因。

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.

推荐答案

我做了这台机器的Active Directory域控制器，所以这款机器现在是一个活动目录的一部分。现在，我可以在本机上连接SSAS实例PBI企业网关，但我的问题在这里并没有结束，我还是没能刷新我的数据，我已经在同一台机器上的SSAS多维数据集来源。我收到错误数据源访问错误，请与Gateway管理员

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，具有相同的名称，我是有在电力BI的帐户。我在Active Directory中进一步改变了用户的UPN给我的力量BI用户的。让说我的域名的名字域和UPN是domain.local，我在AD中创建了[e-mail]新用户，我chnaged的UPN到[e-mail]，因为这是在电力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.

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