问题描述
在 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 分析服务(连接到 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 Desktop.
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.
单击获取数据并选择分析服务.将您的 asazure://粘贴到 Server 文本框中并选中 Import 并单击 OK.在下一个屏幕上，选择左侧的组织帐户选项卡.然后单击登录并选择对您的模型具有权限的 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 服务器时出现错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！