[Power BI][Hubs] MCA support for FinOps hubs and Power BI

[flanakin]

Hi team. We tried working with the Finops tookit and got 4 possible issues, could you please confirm if this is actually a problem, or if we are doing something wrong?

1. The names of the fields in the parquet files are coming with first letter in lowercase and the mapping in Power Query "Expanded Columns" step is considering the first letter as uppercase. This caused most of columns to be empty.
2. The columns BillingAccountId and BillingProfileId were transformed into "Int" datatype but in our extraction it was GUID (text)
3. Our parquet didn't have the column ResourceName (we tried using this formula to get resourname based on resourceID but it doesn't work for AKS for example: = Table.ReplaceValue(#"Replaced Value",each [ResourceName],each Text.AfterDelimiter([ResourceId], "/", {0, RelativePosition.FromEnd}),Replacer.ReplaceValue,{"ResourceName"}) )
4. In the Powerquery step "Add TagsString" the Powerquery function "{" & [Tags] & "}" was not working because it duplicates the JSON braces

Originally posted by @renanalmeidjr in #44 (comment)

[flanakin]

Update on this: The Power BI reports in 0.1 and 0.1.1 both support MCA. The parquet fields are still lowercase, since that's coming from Cost Management, but we already have a fix for that queued up with 0.2. This should resolve both issues 1, 3, and 4.

Cross-posted in the original comment.

[flanakin]

This should be fully resolved with 0.3. Please let us know if anyone runs into any similar issues.