Power BI desktop cannot import data with Azure Cost Management Connector

Question

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.

Answer 1

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!