Forum Discussion

aleki's avatar
aleki
Icon for Microsoft Employee rankMicrosoft Employee
7 years ago

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-the-azure-enterprise-connector) 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

Need Help

7 Replies

  • v-danhe-msft's avatar
    v-danhe-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    7 years ago

    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's avatar
      aleki
      Icon for Microsoft Employee rankMicrosoft Employee
      7 years ago
      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's avatar
        aleki
        Icon for Microsoft Employee rankMicrosoft Employee
        7 years ago
        Hi, any recommendation to help me deal with this problem ? Thanks
  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

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

    • aleki's avatar
      aleki
      Icon for Microsoft Employee rankMicrosoft Employee
      7 years ago

      Problem still opened on my side

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

  • TechCF's avatar
    TechCF
    New Member
    7 years ago

    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.