Custom api powerapps connector for Microsoft fabric

[Nsree]

Hi I would like to make a connection between Microsoft fabric from powerapps custom api connector. Can any one tell me how to create custom api powerapps connector to connect to Microsoft fabric.  Is it feasible to do or not.

[Expiscornovus]

Hi @Nsree,

Don't know if it helps, but you can use the OneLake API and/or Fabric REST API in a Power Automate flow:

https://learn.microsoft.com/en-us/rest/api/fabric/core/onelake-shortcuts/create-shortcut?tabs=HTTP

Nigel Smith has also created a nice blog about this approach with Invoke an HTTP request action in Power Automate: https://www.linkedin.com/pulse/how-call-onelake-api-from-power-automate-enterprise-app-nigel-smith-4...

Below is an example of such a API call 
This example creates a shortcut in a Power Automate cloud flow, which I also shared in this thread.

URI

https://api.fabric.microsoft.com/v1/workspaces/@{variables('WorkspaceId')}/items/@{variables('LakehouseId')}/shortcuts

Body

{
  "name": "PowerAutomateOrdersShortcut",
  "path": "Files",
  "target": {
    "oneLake": {
      "itemId": "773faa37-826f-4f9b-830f-e2a7a23e3903",
      "path": "Tables/orders",
      "workspaceId": "@{variables('WorkspaceId')}"
    }
  }
}

And this is the end result in my example Lakehouse

[v-cboorla-msft]

Hi @Nsree 

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet.
In case if you have any resolution please do share that same with the community as it can be helpful to others.
Otherwise, will respond back with the more details and we will try to help.

Thank you.

[v-cboorla-msft]

Hi @Nsree 

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others .
If you have any question relating to the current thread, please do let us know and we will try out best to help you.
In case if you have any other question on a different issue, we request you to open a new thread.

Thank you.

[v-cboorla-msft]

Hi @Nsree 

Thanks for using Microsoft Fabric Community.

To create a custom connector, you must describe the API you want to connect to so that the connector understands the API's operations and data structures. In this topic, you create a custom connector from scratch, without using an OpenAPI definition to describe the Azure Cognitive Services Text Analytics API sentiment operation (our example for this series). Instead, you describe the connector completely in the custom connector wizard.

For more details please refer to the below links:

Link 1 : Create a custom connector from scratch | Microsoft Learn

Link 2 : PowerApps: Create a simple custom connector from scratch and use it in PowerApps (youtube.com)

I hope this information helps. Please do let us know if you have any further queries.

Thank you.

[v-cboorla-msft]

Hi @Nsree 

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet.
In case if you have any resolution please do share that same with the community as it can be helpful to others.
Otherwise, will respond back with the more details and we will try to help.

Thanks.

[Nsree]

Hi, Thanks for the workaround but i want exact details like api calls to connect to microsoft fabric. If custom connector is not possible can we use powerautomate to make a connection between dataverse and fabric. I have seen couble of articles to connect to fabric for dataverse, but all are not working. So i am looking for custom connector or powerautomate flow. Anything is fine. Thanks in advance