Load your app data into Power BI
Pull a table's records into Microsoft Power BI with a Blank Query that calls the Tadabase REST API and pages through every record.
- Verified Nov 17, 2026
- Classic builder
On this page
Microsoft Power BI can load a table's records straight from the Tadabase REST API. You paste a short query into Power BI, and it reads the records page by page into a table you can report on.
Before you start #
- An API key for your app with Allow Reads turned on. Copy its App ID, API Key and API Secret. See Getting API keys.
- The ID of the table you want to load. You can list your tables and their IDs with the API's
GET /api/v1/data-tablescall; see the REST API overview. - Power BI Desktop, installed from Microsoft.
Add the query in Power BI #
- Start a blank query In Power BI Desktop, choose Get Data > Blank Query. The Power Query Editor opens.
- Open the Advanced Editor Right-click the new query and choose Advanced Editor.
- Paste the query Replace everything in the editor with the query below, and put your table ID, App ID, API Key and API Secret in place of the four
REPLACE_WITH_...values.
let
apiUrl = "https://api.tadabase.io/api/v1/data-tables/REPLACE_WITH_TABLE_ID/records",
perPage = 100,
Headers = [
#"X-Tadabase-App-Id" = "REPLACE_WITH_APP_ID",
#"X-Tadabase-App-Key" = "REPLACE_WITH_API_KEY",
#"X-Tadabase-App-Secret" = "REPLACE_WITH_API_SECRET"
],
GetPage = (page as number) =>
let
Url = apiUrl & "?page=" & Text.From(page) & "&limit=" & Text.From(perPage),
Json = Json.Document(Web.Contents(Url, [Headers = Headers]))
in
Json,
GetRecords = (page as number, collected as list) =>
let
Data = Function.InvokeAfter(() => GetPage(page), #duration(0, 0, 0, 2)),
AllItems = List.Combine({collected, Data[items]}),
Result =
if page >= Data[total_pages]
then Table.FromRecords(AllItems)
else @GetRecords(page + 1, AllItems)
in
Result,
Records = GetRecords(1, {})
in
Records - Run it Click Done. Power BI asks how to connect to the URL the first time: choose anonymous access, because the credentials travel in the query's headers.
- Rename the columns Each field arrives under its field slug, such as
field_58. Rename the columns to names you recognise. - Load the data Click Close & Apply. The table's records are now available for your reports, and Refresh in Power BI reloads them.
How the query pages through records #
The API returns records one page at a time. Each response has the records in items, plus total_items, total_pages and current_page. The query asks for page 1, then keeps asking for the next page until it reaches total_pages, and joins the pages into one table.
limitis the number of records per page. The API caps it (at 100 by default), so asking for more does not return more per page; keepperPageat 100.- The query waits two seconds between pages so a large table does not run into your plan's API rate limits. Each page counts as one API call.
Which records Power BI sees #
The query signs in with the API key only, not as an app user, so it reads every record in the table. Record-level security rules, which filter records per user, do not apply to these calls. Anyone who can open your Power BI file sees all of the table's data, so share it with care, and turn off or delete the API key if the file is no longer needed.
Was this page helpful?
Something wrong or missing on this page? Tell us.