Forum Discussion
Solved
How would you model this ?
How would you go about in modelling this requirement on power query or on dax 1 Import Dataset coming in every (A) 4 hours averaging 50 rows with city as primary field, need to store this in Power B...
curiouspbix0 Yes sir
So you would rather use bridge tables & Dax to Power Query processed dataset that would result one table with master and transactional together which is obviously better on report refresh visual runtimes with a trade off on backend ETL on Power query.
curiouspbix0 Yes sir