Good News!
Recently, Microsoft has introduced Elastic Query, which allows to run a T-SQL query across multiple Azure SQL databases.
Reporting tools like Power BI, Tableau, Excel etc can now leverage the power of elastic query to pull data from multiple databases. For details visit below link.
Resources:
https://docs.microsoft.com/en-us/azure/sql-database/sql-database-elastic-query-overview
Leave a Reply