azure cost management connector
- Is your issue happening in two apps you created from workspaces on Power BI service?
It’s used by the client and employees of Dimension Data. One Dashboard/report is used for Billing Info, the other for Governance.
- The point of the problem is that the data in the app is different from the billing data displayed on Azure portal, right?
Yes, for some Applications the cost in Azure Portal: Cost Management + Billing (Cost Analysis) is different than in the Power BI dashboard/report, due to Application tags being blank.
Azure Cost Management connector for Power BI, Expand / Extract / Split Out Tags.
When extracting the ( application : ……… ) field from Tags column to get Application column,
the Application column is populated correctly for about 95% of the records.
The other 5% contain some badly populated tags which obviously will end up blank (they only have createdon date field), and some properly populated tags which also end up blank.
Not sure if they were blank initially, and after refresh the Tags column is now populated, but the Application column still blank or if there is a slight difference in the Tags for those few columns, or if my splitting of tags method is incorrect).
Guess the quickest way to resolve issue is to verify with Microsoft if the method I use for extracting Tags is correct.
If the method I use for extracting Tags is incorrect, then apply correct method from Microsoft, and verify afterwards if problem resolved.
If the method I use for extracting Tags is correct, then assume tagging issue by IT Admin guys or client.
Below is the method I use to Expand / Extract / Split Out the Tags
- Will you get same issue in the original report?
Yes, I do.
- If refresh the report dataset, will data sync with Azure portal?
Yes, the Power BI dashboard/report gets its data via the Azure Cost Management connector for Power BI.