Forum Discussion

jsmn's avatar
jsmn
Frequent Visitor
5 years ago
Solved

All Measure Formatting Lost with Direct Connect to PBI Dataset

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

 

 

Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    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.

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    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's avatar
      jsmn
      Frequent Visitor
      5 years ago

      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). 

  • mattcarter865's avatar
    mattcarter865
    Icon for Helper I rankHelper I
    4 years ago

    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.

  • mbutler71's avatar
    mbutler71
    Icon for Advocate I rankAdvocate I
    2 years ago

    This requires a lot of re-work on the measures to restore the formatting. 
    Is there a fix planned for this?