Warehouse and SQL

A Warehouse & SQL source connects to a Fabric Warehouse or SQL database. You can bring in a whole table or the result of a SQL query, read directly over OneLake.

Connecting

  • Pick the table you want, or
  • Write a SQL query to shape, join, or pre-filter the data before it reaches the map.

Set a location (longitude/latitude columns or a geometry column) so the results can be drawn on the map.

Aggregating at source

Because this source runs SQL, Icon Map can aggregate at source — computing totals and groupings on the full dataset in the Warehouse — so summaries are exact even when only a sample of rows is drawn on the map.

Next steps