Datahub → your everyday tools

Your data. Ready to use.

Choose a shared dimension below, or connect your current workbench with its selected filters and calculations. Downloads stay on your device.

Data to connect

Use this data in your tools

Snapshots contain the current results. Connections refresh the same selections from public sources; revised values may change.

Excel

A real workbook with a Data sheet and source details. Open the downloaded file in Excel.

Power BI

Open the connection file in Power BI Desktop. Choose Anonymous → Connect → Load. Refresh retrieves your selections again.

Tableau

Download the results, then choose Connect → Text file in Tableau. Use comma delimiter, UTF-8 and English (United States) number locale.

Python

Your URL is already included. Open the notebook in Jupyter or upload it to Google Colab, then run the cell. No packages required.

Refresh in Excel, copy a data link, or troubleshoot

For Excel refresh: Data → Get Data → From Other Sources → Blank Query → Advanced Editor. Paste the complete query below and choose Anonymous. The same query works in Power BI. It requires no RecipeJson parameter.

If Power BI remembers incorrect credentials, use File → Options and settings → Data source settings → select Datahub → Clear Permissions, then reconnect with Anonymous. Scheduled refresh depends on your tenant and must be configured in Power BI Service.

A busy provider may return Retry-After. Wait before refreshing again. No account or API key is needed for Datahub’s public sources. Connection files do not install or launch desktop applications automatically.

Need another dataset? Find data, add it to your workbench, then use its “Open in your tools” section.

API documentation and advanced recipes

Public API contract and examples · OpenAPI 3.1.1 JSON

The versioned recipe API accepts Live recipe exports at POST /api/v1/recipes/run. Existing Python and Power Query recipes continue to work.

Limits: eight sources, 12,000 observations per source, 2 MiB POST input and 20 MiB output. Compact connection links have a smaller size limit. Source licensing and attribution remain applicable: Sources and terms.

File formats follow the official Power BI connection documentation and Tableau text-file guide.