Forum Discussion
Switch datasource from Merged Query to Semantic Model
Hi,
I have build my report basing on MergedQuery and all DAX calculations are under this query too.
However Refreshing datasource through import mode takes hours (same source in other BI tool refreshes in 3 minutes in import mode).
I had to try to prepare semantic model to check whether it performs better.
1) I am wondering whether is it possible to move all my dax calcs to this model in automated way somehow or I need to manually copy and paste?
2) Is it possible to switch somehow source of my report from Merged Query to Semantic Model after achieving 1)?
Thanks!
7 Replies
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
LinkedinSzokens , 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
Linkedin
What is MergedQuery? Are you talking about normalization (ie separating dimension tables from fact tables) ?
