Replacing a dim table with anothe

[Nazdac911]

Hi All 

I have a dim table that is connected to more the 40 table in my model and used in many visuals (this table is saved inside SQL) 

We want to replace this dim table with another one that is saved in a sharepoint location. 

Is their a best practise way to achive that without needing to rebuid the whole datamodel and updating all visuals !! 

Thanks in advance 

Regards 

[ppm1]

Yes. Here are the steps:

1. Right click on current query and choose duplicate (to make a backup copy of query, if needed). Disable load on it and delete it once remaining steps successful.

2. Create your new query based on the SharePoint source, so that it reproduces the current table (same column names, etc.).

3. Open the Advanced Editor on #2 and copy all the M code there. Close the editor. Delete the #2 query once the remaining steps are successful.

4. Open the Advanced Editor on your original query (the one will all the relationships in your model). Paste the new M code over all the existing M code.

5. Load the updated table/query and confirm all is well.

Pat