Using an on-premises data gateway to query an API using Python for your dashboards.

Going beyond field equality-based join conditions in Power Query.