nocodb

Free & open source Airtable alternative

Integrate the nocodb API with the Microsoft Power BI API

Setup the nocodb API trigger to run a workflow which integrates with the Microsoft Power BI API. Pipedream's integration platform allows you to integrate nocodb and Microsoft Power BI remarkably fast. Free for developers.

Cancel Dataset Refresh with Microsoft Power BI API on New Update in Table from nocodb API
nocodb + Microsoft Power BI
 
Try it
Add Record with nocodb API on Dataset Refresh Completed from Microsoft Power BI API
Microsoft Power BI + nocodb
 
Try it
Add Record with nocodb API on Dataset Refresh Failed from Microsoft Power BI API
Microsoft Power BI + nocodb
 
Try it
Add Record with nocodb API on New Dataset Refresh Created from Microsoft Power BI API
Microsoft Power BI + nocodb
 
Try it
Add Rows to Dataset Table with Microsoft Power BI API on New Record in Table from nocodb API
nocodb + Microsoft Power BI
 
Try it
Dataset Refresh Completed from the Microsoft Power BI API

Emits a new event when a dataset refresh operation has completed. See the documentation

 
Try it
New Record in Table from the nocodb API

Emit new event for each new record in table. See the documentation

 
Try it
Dataset Refresh Failed from the Microsoft Power BI API

Emits an event when a dataset refresh operation has failed in Power BI. See the documentation

 
Try it
New Update in Table from the nocodb API

Emit new event for each update in table. See the documentation

 
Try it
New Dataset Refresh Created from the Microsoft Power BI API

Emit new event when a new dataset refresh operation is created. See the documentation

 
Try it
Add Record with the nocodb API

This action adds a record in a table. See the documentation

 
Try it
Add Rows to Dataset Table with the Microsoft Power BI API

Adds new data rows to the specified table within the specified dataset from My workspace. See the documentation

 
Try it
Delete Record with the nocodb API

This action deletes a row in a table. See the documentation

 
Try it
Cancel Dataset Refresh with the Microsoft Power BI API

Cancels a refresh operation for a specified dataset in Power BI. See the documentation

 
Try it
Get Record (from row number) with the nocodb API

This action gets a row by row Id. See the documentation

 
Try it

Overview of nocodb

The NoCodeB (NocoDB) API transforms your databases into a smart Excel sheet, providing a platform for managing your data with the ease of a spreadsheet interface. When combined with Pipedream's capabilities, this API allows you to automate data operations, sync with other databases or apps, and streamline workflows without writing complex code. Using Pipedream, you can trigger events based on changes in your NocoDB, process and manipulate the data, and connect to countless apps to extend functionality, such as sending notifications, updating CRMs, or generating reports.

Connect nocodb

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
import { axios } from "@pipedream/platform"
export default defineComponent({
  props: {
    nocodb: {
      type: "app",
      app: "nocodb",
    }
  },
  async run({steps, $}) {
    return await axios($, {
      url: `https://${this.nocodb.$auth.domain}/api/v1/db/meta/nocodb/info`,
      headers: {
        "accept": `application/json`,
        "xc-token": `${this.nocodb.$auth.api_key}`,
      },
    })
  },
})

Overview of Microsoft Power BI

The Microsoft Power BI API allows you to interact with your Power BI assets programmatically. With this API, you can embed your reports and dashboards into applications, manage Power BI datasets, push data into datasets for real-time dashboard updates, and automate your reporting workflows. On Pipedream, you can use this API to create intricate workflows that react to various triggers, like webhooks or schedules, and perform actions like refreshing datasets, posting to datasets, and managing Power BI assets.

Connect Microsoft Power BI

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
import { axios } from "@pipedream/platform"
export default defineComponent({
  props: {
    microsoft_power_bi: {
      type: "app",
      app: "microsoft_power_bi",
    }
  },
  async run({steps, $}) {
    return await axios($, {
      url: `https://api.powerbi.com/v1.0/myorg/availableFeatures`,
      headers: {
        Authorization: `Bearer ${this.microsoft_power_bi.$auth.oauth_access_token}`,
      },
    })
  },
})