Skip to main content

Power BI

New

Replace Data Source & Replace References

Vote (4) Share
Michael Seim's profile image

Michael Seim on 22 Mar 2023 15:41:00

I think it'd be nice to have features to do the following:

  1. Replace Data Source
  2. Right click on a data source
  3. Select "Replace Data Source"
  4. User selects another data source
  5. All references to the prior data source are replaced with the newly selected data source
  6. Replace Reference
  7. Right click on a field or measure
  8. Select "Replace references"
  9. User selects another field or measure
  10. All references to the prior field or measure are replaced with the newly selected field or measure
Comments (1)
Michael Seim's profile image Profile Picture

Stephen Stroup on 16 Aug 2024 17:48:52

RE: Replace Data Source & Replace References

This would save me so much time when data structure is updated in my DirectQuery source or Datamart.E.g. we broke what were once fields in the fact table into a new dimension table, or a table gets renamed or a field name changes. Rather than go through all of the pages and visuals in a report, just right click on the original column or measure and say "Replace with" and pick the new column or measure, and then that's replaced throughout the entire report without needing to go visual by visual, filter by filter, and manually replace them all.Tableau has this feature and it's missed here.