I'd like to Follow up on this, as I have the same behaviour in all me DirectQueryConnection to PowerBI-Datasets which themselves have advanced format string expressions - also with Calculation Groups with Format Expression strings which seem to create those hidden "Format String Measures" display folders.
1. I have a local "model" with a simple tabel
2. I connect to a PowerBI Dataset which has advanced format Expression strings.
All the measures are NOT formatted at all
Although the measures do have their individual Format Strings: Here an Example for OEE - with the special "Format String Measures" display folder, which seem to appear somehow, as soon as you create Calculation Groups with Format expressions via Tabular Editor :
3. I go to Tabular Editor to change these format string e.g: for NEE % "#,##0.000%" and Save
4. then everything shows up as expected
5. If i hit the Refresh button locally, the (empty) Format string seems to be taken again from the external dataset and reverts my local format string I just applied before:
Back to square 1...
===
So the questions:
- Why does it not import the Format from the external Dataset?
- Why is my locally changed Metadata Format String not kept? If I disable "include new tables..." my local Format strings are kept, but there are continuous enhancements on the external dataset going on which I eventually need
- Could it have something to do with other not so obvious Power BI settings (e.g. I have Infrastructure Update deactivated...)
- So: any Ideas for settings, workarounds? -> Main goal is to get the source Format Strings to get pushed through
Thanks!