Updating FormatString from external tool does not update Power BI Desktop

Greg_Deckler — Sun, 13 Mar 2022 15:33:58 GMT

OK, so I have a C# WPF external tool built for Power BI. Basically, a metadata editor. Everything works editing the metadata except the FormatString for Columns and Measures. But here's the thing, if I set a custom format string for a column or measure, the custom format string is changed such that if I am in Power BI Desktop and change the Format from something like General to Custom, then the custom format string is there and works. But, Power BI Desktop does not automatically recognize that the format should be Custom.

Even weirder. If I change a DateTime column from Short Date to Long Date, I can see that the change happened in Tabular Editor but Power BI Desktop continues to display Short Date instead of Long Date.

Was curious if anyone knew of why FormatString is acting like this. Again, everything else works, I can hide tables/columns/measures, set the Description and even change the home tables of measures. But FormatString is just acting weird.

Re: Updating FormatString from external tool does not update Power BI Desktop

Greg_Deckler — Sun, 13 Mar 2022 17:43:06 GMT

OK, so after struggling with this most of yesterday and today, I finally figured it out. You have to remove the Format annotation from the object to force Power BI Desktop to update. So:

metadataobject.Annotations.Remove("Format")

topic Re: Updating FormatString from external tool does not update Power BI Desktop in Developer

Updating FormatString from external tool does not update Power BI Desktop

Re: Updating FormatString from external tool does not update Power BI Desktop