Forum Discussion
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...
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
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