Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
jsmn
Frequent Visitor

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:

jsmn_2-1620999770541.png

 

 

DirectQuery:

jsmn_1-1620999716300.png

 

Any insight would be greatly appreciated. Thank you!

 

Jeff

 

 

1 ACCEPTED SOLUTION
v-yangliu-msft
Community Support
Community Support

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.

View solution in original post

4 REPLIES 4
mbutler71
Advocate I
Advocate I

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

mattcarter865
Helper I
Helper I

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
Community Support
Community Support

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.

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

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.