All Measure Formatting Lost with Direct Connect to PBI Dataset

[jsmn]

Hello,

I've created a new report with a direct connection to an existing PowerBI dataset. Upon copying/pasting visuals between reports I noticed that all of the measure formatting was lost. This happens immediately upon switching from a live connection to a local model. The purpose here was to use a central model but then include additional data sources for a specific customer. I am able to update the formatting in the new PBIX on a measure-by-measure basis, but with hundreds of measures I need to find a way to do this in bulk. See example below:

Original:

DirectQuery:

Any insight would be greatly appreciated. Thank you!

Jeff

[mattcarter865]

I see the same issue as well. I don't really understand how the accepted solution here addresses the problem of the measure formatting being lost/altered when switching to DirectQuery to AS mode.

[v-yangliu-msft · Accepted solution]

Hi  @jsmn  ,

Live connection connection mode cannot add the data source. You can add this new datasource that needs to be added to the previous datasource to form a new datasource, so that the measure will not be lost.

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[jsmn]

Thank you! Unfortunately, that won't work for our use case. We have a "master" data source for all of our clients, but the secondary datasets are client-specific and very large. We wouldn't be able to pull all of them into one data source (without upgrading to premium, at least).