Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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.
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.
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).
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
100 | |
80 | |
63 | |
58 |
User | Count |
---|---|
148 | |
111 | |
94 | |
84 | |
67 |