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