Read a Table API with Power Query

Power Query can read a MiniUp Table API and turn its records into a worksheet or report. Use this workflow when you want a refreshable view in Excel or Power BI.

Before connecting Power Query

Copy the Table’s public API URL and confirm GET is enabled. The example below uses public read access and returns the first 100 records. For private data, use an appropriately secured credential workflow rather than distributing a workbook containing a private key.

Add a Power Query

1. In Excel or Power BI, create a blank query and open its Advanced Editor.
2. Paste the query below and replace the URL with the Table URL shown by MiniUp.
3. Run the query and inspect the returned columns.
4. Load the result into your worksheet or model. Refresh it when you need current records.

let
  Source = Json.Document(Web.Contents(
    "https://my-site.miniup.app/api/data/my-site/customer-leads",
    [Query = [limit = "100", offset = "0"]]
  )),
  Rows = List.Transform(Source[records], each [fields]),
  Result = Table.FromRecords(Rows)
in
  Result

Fetch more than one page

The example is intentionally bounded. For a larger Table, create a pagination query that advances offset and combines returned pages until no records remain. Do not assume one response contains all records. A Table export is useful when you need a one-time full copy rather than a refreshable connection.

Troubleshoot Power Query

A 401 or 403 requires checking Table access and credentials. A missing column may reflect the Table’s actual schema or an empty response. If the source data changed, refresh the query and review downstream transformations.

Related guides

• Public Table API reference
• Table permissions
• Parquet and DuckDB