- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Help needed with data remodeling
Hello,
Here's a tricky requirement - My report has an old column for id, named 'ID'. This id is used in relationships with two other tables in the Power BI data model. Also, 'ID' is used in over 50 measures and calculated columns. Recently, we received information from the backend team that they will no longer be sending this ID data and will now send new data in a new column called 'ID_new'. The data in 'ID_new' column will be populated for all historic data as well.
To accommodate this change, one option that I have is to redo the modeling and update the relationships; and replace 'ID' with 'ID_new' in all the calculated columns and measures manually. Is there any other suggestion for making the changes more efficiently?
Many thanks!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi @Anonymous ,
Based on your description, the new column seems to be similar to the old one?
If so, you may consider creating a new table with 'ID_new' column and using Append in Power Query to combine the two tables, so that you can continue to use the new data on top of the original model to avoid re-modeling.
For more details, please refer to:
Append queries - Power Query | Microsoft Learn
Append Queries in Power BI - SqlSkull
Best Regards,
Jianbo Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
11-07-2019 12:20 PM | |||
Anonymous
| 08-15-2024 01:19 AM | ||
07-16-2024 04:39 AM | |||
12-06-2023 04:27 PM | |||
06-07-2023 08:52 AM |