Replace a table in data model

[Anonymous]

I built a report with a quite complex data model. Now I need to replace a table (involved in multiple relationships) with another one that has the same structure (i.e. same columns) but entirely different data, and is imported differently, so I can't simply append my new data to the old table. 

Is there a way to replace the old table with the new one, without having to re-set manually all the relationships?

[v-jingzhang]

Hi @Anonymous  

There are two common methods you may consider which depends on your data source type.

If your new table has the same data source type with your old table, you can change the data source easily in Data source settings. The data from the new data source will then be used in your report after applied.

If your new table has a different data source type from the old one, you can create a new query connecting to the new table source, then go to Query Editor->Advanced Editor, copy the Source statement and paste it in your old table query’s Advanced Editor to replace its Source. At last, you can delete the new query created in previous step.

For more details and examples, you may refer to these links:

https://blog.decisivedata.net/blog/change-a-power-bi-data-source-type

https://community.powerbi.com/t5/Desktop/Change-excel-datasource-to-Web-sharepoint-file/td-p/330296

https://community.powerbi.com/t5/Desktop/Change-of-data-source-from-excel-to-sharepoint/td-p/515417

Best Regards,

Community Support Team _ Jing Zhang

If this post helps, please consider Accept it as the solution to help other members find it.

[amitchandak · Accepted solution]

@Anonymous , if you want append

https://radacad.com/append-vs-merge-in-power-bi-and-power-query

If can you want replce.

Open Transform Data /edit query mode. Right click on table and open advace editor. Carefully replace the script with the new table script so that the table name remains same.  Keep a backup of file.

Please provide your feedback comments and advice for new videos
Tutorial Series Dax Vs SQL Direct Query PBI Tips
Appreciate your Kudos.

[Anonymous]

@amitchandak ,

Thank you for the answer to that question. 

I built a great BI_Calendar in PBI. But, that should be placed into the Datawarehouse for resource efficiency (many DAX columns were added). 

If a Calendar with table name and column names were made BUT HAD ADDED COLUMNS not in the BI_Calendar now would that import and PBI just bring in the added columns? Or, would it blow up? 

Thank you for your great answers!