My company is using the MS platform and I need to retrieve data from a Knack database for a Power Apps app. I couldn’t find any connector or custom connector for Knack. Anyone was able to build a custom connector to access Knack API and could point me somewhere? Thanks in advance
Not my area of speciality but you may want to look at Make (formerly Integromat) which enables you to connect Knack to MS products with pre baked modules.
This is a good suggestion. Using Make, we can easily create some simple pipelines to transfer data over to our PBI service dataset for use within the Power Platform. It’s almost like a cheap data warehouse solution and allows for much much easier access than making API calls.
Other workarounds would be to simply use Make to update an Excel sheet on OneDrive or SharePoint, or connect to Knack using dataflow (Power Query). I think using the PBI dataset is a much better solution since all of it is baked together a little better when connecting to a published dataset and because doing full queries against an object with thousands of records rather than doing incremental updates can be quite slow.