Linkink Knack to Power BI

API & Custom Code Ask Developers
1

Good day all.

Im a newbie here, and im wondering if i can conect my knack to power bi, and if so, how it is done, if their is a tutorial that i can check, i will appreciate it a lot!

thanks!

2

Hey @carlos.ortiz, I have just published a Querying Knack from Power BI how-to to my Substack channel here. There will be a more extensive version soon.
Feel free to reach out if you have any questions or feedback!

3 Likes
3

Hi Stephen - I have tried multiple times to connect to both Excel and Power BI from different apps and keep getting the (400) Bad Request. Tried with Make also but get same error. The only one that seems to work is Zapier but I would really like to connect to Power BI.

4

If you haven’t already, download and install Power BI Desktop from the Microsoft website. It’s a free application for creating reports and visualizations. In Power BI Desktop, go to the “Home” tab and select “Get Data.” Choose the appropriate data source option (e.g., Web, JSON, CSV) depending on how you’re accessing your Knack data. If you’re using the Knack API, you’ll need to enter the API endpoint URL and any required authentication details (API key, OAuth token, etc.). If you’re using a file export, simply navigate to the file location.

1 Like
5

Yes, you can connect Knack to Power BI, though it takes a few steps as Power BI doesn’t have a built-in Knack connector.

  1. Using the Knack API: Knack provides an API to access your data, which you can use to set up a connection in Power BI. In Power BI, use the Web connector to make GET requests to the Knack API, pulling in your data. You’ll need your Knack API key and basic understanding of how to structure requests. Knack’s API documentation can guide you through this.
  2. Third-Party Tools: Consider using tools like Zapier or Integromat, which can link Knack to Google Sheets. Power BI can then easily connect to Google Sheets to pull the data in.

Both options work, so choose based on your comfort level with APIs or third-party tools!

6

Just for clarity, Integromat is now Make.com :pray:

7

Welcome! Yes, you can connect Knack to Power BI, but it requires a bit of setup since Knack doesn’t have a native Power BI connector. You can try these methods:

:one: Using the Knack API – You can pull data from Knack into Power BI via Power Query (M) by making API calls. Knack provides a REST API that allows you to retrieve data in JSON format.

:two: Using a Third-Party Connector – Some middleware tools like Zapier, Integromat (Make), or Skyvia can help automate data transfers between Knack and Power BI.

:three: Export & Import – If it’s a one-time or periodic update, you can export data from Knack as CSV and then load it into Power BI manually.