Power BI桌面无法使用Azure Cost Management连接器导入数据 [英] Power BI desktop cannot import data with Azure Cost Management Connector

问题描述

我最近开始使用

我正在使用我们组织的注册号和密钥.我尝试了

点击连接

为企业协议帐户选择注册号

输入或粘贴您的注册号码

选择要查看的月数

点击确定

登录到您的Azure AD帐户，然后单击连接

选择所需的表，然后单击加载

这时，Power BI应该加载数据，这可能需要一段时间，具体取决于您拥有的数据量.

我注意到，如果您已经登录，那么Power BI可能会在步骤7中选择一个现有的Azure AD帐户.我怀疑这就是您要面对的.如果是这种情况，您只需在上面的步骤8中单击加载并忽略预览错误，然后通过以下步骤更改您使用的帐户:

1. 文件>选项和设置>数据源设置
2. 选择 Azure成本管理，然后点击编辑权限...
3. 点击修改...
4. 点击以其他用户身份登录，切换到对注册具有读取权限的帐户，然后点击保存
5. 点击确定，然后点击关闭

那应该给您您所需要的.希望这会有所帮助！

I recently started using the Azure Cost Management connector for Power BI. The idea is to get Azure consumption data to PBI and generate some reports. However, I'm getting the following error when trying to load the data:

The user does not have any claims associated

I am using our organization's Enrollment Number and the Key. I tried the Azure Consumption Insights connector and it worked without an issue and I was able to import data into PBI desktop app.

Do we need to enable anything from our organization's Enterprise Agreement side of things, to be able to use the new connector? Any suggestions would be fantastic.

解决方案

The Azure Cost Management connector for Power BI uses Azure AD instead of the old EA API key. You should be prompted for credentials when you setup the connector. Here's the typical flow:

1. Get Data > Azure > Azure Cost Management
2. Click Connect
3. Select Enrollment Number for Enterprise Agreement accounts
4. Type or paste your enrollment number
5. Select the number of months you want to see
6. Click OK
7. Sign in to your Azure AD account and click Connect
8. Select the desired tables and click Load

At this point, Power BI should load the data, which may take a while, depending on how much data you have.

I noticed that Power BI may select an existing Azure AD account in step 7, if you're already signed in. I suspect that's what you're facing. If that's the case, you can just click Load in step 8 above and ignore the preview error, then change the account you use by going to:

1. File > Options and settings > Data source settings
2. Select Azure Cost Management and click Edit Permissions...
3. Click Edit...
4. Click Sign in as different user, switch to an account that has read access to the enrollment, and then click Save
5. Click OK, then Close

That should give you what you need. Hope this helps!

这篇关于Power BI桌面无法使用Azure Cost Management连接器导入数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！