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.c...
Need Help
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