Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
aleki
Employee
Employee

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

7 REPLIES 7
TechCF
New Member

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
Not applicable

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

Problem still opened on my side

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

kalaptarto
New Member

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

v-danhe-msft
Employee
Employee

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.

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

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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors