Reply
avatar user
Anonymous
Not applicable

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!

1 REPLY 1
v-jianboli-msft
Community Support
Community Support

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.

avatar user

Helpful resources

Announcements
March PBI video - carousel

Power BI Monthly Update - March 2025

Check out the March 2025 Power BI update to learn about new features.

March2025 Carousel

Fabric Community Update - March 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)