Power Users - Microsoft Power Platform

Microsoft Power Platform offers multiple solutions that can leverage APIs. Most solutions use custom connectors to connect to APIs, while some require a low-code solution.

PowerApps and Power Automate

Both Power Apps (canvas apps) and Power Automate use custom connectors to connect to APIs. For non-canvas apps, Power Apps API connectivity must be coded.

Picture

The Core API connector can be found here:

https://make.powerapps.com/environments/Default-07420c3d-c141-4c67-b6f3-f448e5adb67b/customconnectors

If there are any issues with the connector please contact the API team. For issues with Power Apps in general, please contact the KTG-ECM team.

Power BI

Power BI also uses a custom connector for custom APIs.

Picture

Using the custom connector in Power BI:

  1. Download the file here

  2. Copy the extension file into the [Documents]\Power BI Desktop\Custom Connectors directory

  3. Open Power BI Desktop

Note, to load extensions for use in Power BI, you will need to lower the security level for extensions in Power BI Desktop to enable loading unsigned/uncertified connectors.

  1. Go to File | Options and settings | Options

  2. Go the Security tab

  3. Under Data Extensions, select "Allow any extension to load without warning or validation"

  4. Restart Power BI Desktop