Knack Connector for Power Query (Excel/Power BI)

API & Customization Show & Tell
1

I’ve just finished building a Knack connector for Power Query (Excel or Power BI).

It effortlessly retrieves all records (with pagination) from any grid/list view within your Knack app, and auto expands/renames columns so you don’t have to.

If this is something that interests you, feel free to reach out to me for access to the installation instructions and function code.

You can also read my Substack post on how to set up a basic query from scratch.

5 Likes
2

Hi Stephen,
very interested in this! Does your connector also do pagination to retrieve more than 1000 records?

3

Hi @Stefan, yes, it will grab all available records in your specified view, even if it’s more than 1,000.
Important to note that the more records or fields you want to export, the slower the query.

Happy to discuss further via direct message if you’re interested!