Forum Discussion

curiouspbix0's avatar
curiouspbix0
Icon for Helper IV rankHelper IV
6 years ago
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...
Need Help
Tips and Tricks
curiouspbix0's avatar
curiouspbix0
Icon for Helper IV rankHelper IV
6 years ago

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.