I have 5 global teams (Australia, Japan, USA and France, Germany and Italy) that need access to a single-instance DB for Power BI and SSRS reporting. We have looked at the Azure DW, but it is cost prohibitive. I was thinking of creating a schema in a single instance, and then have Azure Data Factory push data in.
The only concern that I now have is performance and availability. It has to be performant and available 24/7 for global teams to access. What should I consider?