Forum Discussion
Switch datasource from Merged Query to Semantic Model
Hi Szokens ,
If the table structure is the same, you can use Tabular Editor to copy measures from one place to another or use the ALM Toolkit.
| Resident Rockstar | Former Super User If I helped, please accept the solution and give kudos! Connect with me |
Hi lkalawski ,
Thanks! This tool looks really nice, however my company doesn't allow me to download any external tools (download is automatically blocked).
is ALM Toolkit also external?
Szokens , Yes, I have not heard of a portable version for ALM Toolkit.
But if you are moving measures that use one Merged table to a semantic model, you will probably still have to update the measure definitions and apply them to the appropriate tables.
So you won't avoid manual work, unfortunately.
Resident Rockstar | Former Super User
If I helped, please accept the solution and give kudos!
Connect with me
LinkedinThat is right, I have learned so fat that DAX formulas used in merged queries shall to be re-written to capture proper logic when moving to semantic model anyway.