How to merge 20 reports/semantic models?
What’s the best way to take bits and pieces of information for 20+ reports and brining that all together and joining them by date and location? These reports live with different departments at the company. What’s the out of the box thinking approach I should consider or should I just direct query all these reports and semantic models into one big semantic model?