Can I update an M query on the service? #1441
-
|
I need to update an M query on the service on one of the DIM tables used in a composite model and the fact table is incrementally refreshed. I am trying to avoid a full refresh if I update the desktop version and upload it to the service. The change I am trying to make is simple and intended map to a different table / View. I have TE 3.19.0 (and love it) but I can't find an obvious way to do that. Please advise. |
Beta Was this translation helpful? Give feedback.
Replies: 2 comments
-
|
Go to the PARTITION data of the DIM table and it should be all of the M code for that table. If the M code is adding or changing the table schema (new columns) you need to, after saving your M code, right click on the table and "Detect Schema" then refresh the table. |
Beta Was this translation helpful? Give feedback.
-
|
Thanks Ed. Now I know. |
Beta Was this translation helpful? Give feedback.
Go to the PARTITION data of the DIM table and it should be all of the M code for that table.
Make the change, save it, and the right-click and refresh that table.
If the M code is adding or changing the table schema (new columns) you need to, after saving your M code, right click on the table and "Detect Schema" then refresh the table.