Microsoft Azure Consumption Insights ('BillingMonth' duplicate)

[aleki]

Hi,

I'm using Azure Consumption Insights to get the billing insights of my Enterprise Agreement.

Everything goes fine when I use the (beta) connector on PowerBI desktop (https://docs.microsoft.com/en-us/power-bi/desktop-connect-azure-consumption-insights#migrating-from-...) but the refresh fails via PowerBI service.

Below is the error message I get - As I don't have access to the data sources, how can I fiw this duplicate issue to make it work ?

---------------------------------------------

Microsoft Azure Consumption Insights has failed to refresh.
Failure details:

Column 'BillingMonth' in Table 'Summaries' contains a duplicate value '2018-02' and this is not allowed for columns on the one side of a many-to-one relationship or for columns that are used as the primary key of a table. Table: Summaries.

---------------------------------------------

Thanks

[TechCF]

I'm having the same issue, but for the month of august. It might have something to do with the annual anniversary of an EA agreement, as it happened right after.

[Anonymous]

Having the exact same issue, anyone know what the deal is?

[aleki]

Problem still opened on my side

I'm using the PowerBI desktop connector but the PBi online dashboard still doesn't work for me

[Anonymous]

Hi, I have the same issue with the report, did you find any solution to this? Thanks.

[v-danhe-msft]

Hi @aleki,

Based on my research, it seemed something wrong with your duplicate data or your relationship, I suggest you first check the relationship in Manage Relationships to see if correct relationships are created. Then, go to Query Editor,  right click the [BillingMonth] Column select "Remove duplicate".

Regards,

Daniel He

[aleki]

Thanks for the feedback. I don't have control over the data source, the request or the application : it is provided by Microsoft as well as the application (Get Data > Services > Apps for PowerBI > (search for Microsoft Azure Consumption Insights) > GET IT NOW and then enter the parameters and keys from the EA portal) I've tried again and the problem is still there : https://northeustoaleki.blob.core.windows.net/web/err-pbi.png When I import the table directly from PowerBI desktop, I don't get such an import error whereas the duplicated "BillingMonthID" for 201802 is well there : https://northeustoaleki.blob.core.windows.net/web/PBi-desktop.png There should be something wrong in the query string (or else) is the Microsoft PowerBI apps

[aleki]

Hi, any recommendation to help me deal with this problem ? Thanks