Switch datasource from Merged Query to Semantic Model

[Szokens]

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!

[lbendlin]

What is MergedQuery?  Are you talking about normalization (ie separating dimension tables from fact tables) ?

[Szokens]

sorry for confusion, I have 5 input tables, I have merged them in Power Query using joins to new "Merged Query" table. 

[lbendlin]

Avoid merges in Power Query as much as possible.  Let the data model do the work for you.

[lkalawski]

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.

Tutorial: https://community.fabric.microsoft.com/t5/Community-Blog/Power-BI-gt-How-to-easily-copy-Measures-fro...

Resident Rockstar | Former Super User If I helped, please accept the solution and give kudos!  Connect with me Linkedin

[Szokens]

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?

[lkalawski]

@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 Linkedin

[Szokens]

That 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.