I believe that technically there's not much difference between connection to SQL Azure and SQL Server exposed on the internet. However the first one can be refreshed/access directly from Power BI and...
same here. we're dealing with a company that accepted to provide a read-only access to our database on their premises. but they will not accept installing a Power Bi gateway.
