通过导入模式在Power-BI中连接到Azure SSAS服务器时出现错误 [英] I am getting an error while connecting to Azure SSAS server in Power-BI through Import mode
问题描述
在Power-BI中连接到Azure SSAS服务器时出现错误。
在Power-BI中，我选择SQL Server Analysis Services数据库作为数据源，并选择导入模式。然后抛出一个错误-服务器参数必须是有效的主机名或HTTP URL。
如果我使用实时连接模式，则可以连接，但我想从导入模式进行连接。
I am getting an error while connecting to Azure SSAS server in Power-BI. In Power-BI, I am selecting SQL Server Analysis Services database as a data source and I am selecting Import mode. then it is throwing me an error- "The server parameter must be a valid hostname or HTTP URL." If I use 'Live connection' mode then I am able to connect but I want to do it from 'Import' mode.
所以我怎么获得SSAS服务器的HTTP URL？
so how can I get HTTP URL for SSAS server?
推荐答案
如果我理解您的问题，则说明您正在连接到Azure Analysis Services（连接到asazure：//）。我无法重现此问题，所以我建议一些事情。
If I understand your question, you're connecting to Azure Analysis Services (the one where you connect to asazure://). I wasn't able to reproduce this issue so I would suggest a few things.
-
确保您具有最新的Power BI
Make sure you have the latest Power BI Desktop installed.
在Power BI Desktop中，请确保您使用的身份验证类型正确（组织帐户）。转到文件...选项...数据源设置...全局权限。然后查看您是否发现列出的asazure：//数据源。如果是这样，请左键单击它，然后单击清除权限按钮。这将导致Power BI Desktop下次提示您输入凭据。这样，您可以确保选择正确的身份验证。如果您的asazure：//数据源不存在，请继续执行下一步。
In Power BI Desktop, make sure you are using the correct authentication type (Organizational account). Go to File... Options... Data source settings... Global permissions. Then see if you spot your asazure:// data source listed. If so, left click it then click the Clear Permissions button. That will cause Power BI Desktop to prompt you for credentials next time. This way you can ensure you choose the proper authentication. If your asazure:// data source isn't there, move on to the next step.
单击获取数据并选择Analysis Services。将asazure：//粘贴到服务器文本框中，然后选中导入，然后单击确定。在下一个屏幕上，选择左侧的组织帐户选项卡。然后单击登录，然后选择一个对您的模型具有权限的Azure Active Directory帐户（组织帐户）。然后单击连接。
Click Get Data and choose Analysis Services. Paste in your asazure:// into the Server textbox and check Import and click OK. On the next screen choose the Organizational Account tab on the left. Then click Sign in and choose an Azure Active Directory account (Organizational account) which has permissions to your model. Then click Connect.
这篇关于通过导入模式在Power-BI中连接到Azure SSAS服务器时出现错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
