cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
aleki Frequent Visitor
Frequent Visitor

Microsoft Azure Consumption Insights ('BillingMonth' duplicate)

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

6 REPLIES 6
Community Support Team
Community Support Team

Re: Microsoft Azure Consumption Insights ('BillingMonth' duplicate)

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

 

 

 

 

 

 

Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
aleki Frequent Visitor
Frequent Visitor

Re: Microsoft Azure Consumption Insights ('BillingMonth' duplicate)

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 Frequent Visitor
Frequent Visitor

Re: Microsoft Azure Consumption Insights ('BillingMonth' duplicate)

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

Re: Microsoft Azure Consumption Insights ('BillingMonth' duplicate)

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

hainley Occasional Visitor
Occasional Visitor

Re: Microsoft Azure Consumption Insights ('BillingMonth' duplicate)

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

aleki Frequent Visitor
Frequent Visitor

Re: Microsoft Azure Consumption Insights ('BillingMonth' duplicate)

Problem still opened on my side

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