Forum Discussion

Szokens's avatar
Szokens
Helper II
1 year ago

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 refre...
Tips and Tricks
lbendlin's avatar
lbendlin
Super User
1 year ago

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

Szokens's avatar
Szokens
Helper II
1 year ago

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

  • lbendlin's avatar
    lbendlin
    Super User
    1 year ago

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