Formatting - [Numbers] Format Number with Pipedream Utils API on New Dataset Refresh Created from Microsoft Power BI API

Pipedream makes it easy to connect APIs for Pipedream Utils, Microsoft Power BI and 3,000+ other apps remarkably fast.

Trigger workflow on

New Dataset Refresh Created from the Microsoft Power BI API

Next, do this

Formatting - [Numbers] Format Number with the Pipedream Utils API

No credit card required

▶

Watch us build a workflow

8 min

Watch now ➜

Trusted by 1,000,000+ developers from startups to Fortune 500 companies

Developers ♥ Pipedream

Getting Started#

This integration creates a workflow with a Microsoft Power BI trigger and Pipedream Utils action. When you configure and deploy the workflow, it will run on Pipedream's servers 24x7 for free.

Select this integration
Configure the New Dataset Refresh Created trigger
1. Connect your Microsoft Power BI account
2. Optional- Select a Dataset ID
3. Optional- Configure Custom Dataset ID
4. Configure timer
Configure the Formatting - [Numbers] Format Number action
1. Connect your Pipedream Utils account
2. Configure Input
3. Optional- Select a Input Decimal Mark
4. Select a Output Format
Deploy the workflow
Send a test event to validate your setup
Turn on the trigger

Details#

This integration uses pre-built, source-available components from Pipedream's GitHub repo. These components are developed by Pipedream and the community, and verified and maintained by Pipedream.

To contribute an update to an existing component or create a new component, create a PR on GitHub. If you're new to Pipedream component development, you can start with quickstarts for trigger span and action development, and then review the component API reference.

Trigger#

New Dataset Refresh Created on Microsoft Power BI

Description:Emit new event when a new dataset refresh operation is created. [See the documentation](https://learn.microsoft.com/en-us/rest/api/power-bi/datasets/get-refresh-history)

Version:0.0.1

Key:microsoft_power_bi-new-dataset-refresh-created

View on GitHub

Microsoft Power BI Overview#

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.

Trigger Code#

import common from "../common.mjs";

export default {
  key: "microsoft_power_bi-new-dataset-refresh-created",
  name: "New Dataset Refresh Created",
  description: "Emit new event when a new dataset refresh operation is created. [See the documentation](https://learn.microsoft.com/en-us/rest/api/power-bi/datasets/get-refresh-history)",
  version: "0.0.1",
  type: "source",
  dedupe: "unique",
  ...common,
  methods: {
    ...common.methods,
    checkStatus() {
      return true;
    },
    getSummary() {
      return "New Refresh Created";
    },
  },
};

Trigger Configuration#

This component may be configured based on the props defined in the component code. Pipedream automatically prompts for input values in the UI and CLI.

Label	Prop	Type	Description
Microsoft Power BI	`powerBiApp`	`app`	This component uses the Microsoft Power BI app.
N/A	`db`	`$.service.db`	This component uses `$.service.db` to maintain state between executions.
Dataset ID	`datasetId`	`string`	Select a value from the drop down menu.
Custom Dataset ID	`customDatasetId`	`string`	You may enter a Dataset ID directly. Either Dataset ID or Custom Dataset ID must be entered.
	`timer`	`$.interface.timer`

Trigger Authentication#

Microsoft Power BI uses OAuth authentication. When you connect your Microsoft Power BI account, Pipedream will open a popup window where you can sign into Microsoft Power BI and grant Pipedream permission to connect to your account. Pipedream securely stores and automatically refreshes the OAuth tokens so you can easily authenticate any Microsoft Power BI API.

Pipedream requests the following authorization scopes when you connect your account:

offline_accesshttps://analysis.windows.net/powerbi/api/App.Read.Allhttps://analysis.windows.net/powerbi/api/Dashboard.Read.Allhttps://analysis.windows.net/powerbi/api/Workspace.Read.Allhttps://analysis.windows.net/powerbi/api/Dataset.ReadWrite.Allhttps://analysis.windows.net/powerbi/api/Report.Read.Allhttps://analysis.windows.net/powerbi/api/Report.ReadWrite.All

About Microsoft Power BI#

Visualize any data and integrate the visuals into the apps you use every day with Power BI, a unified platform for self-service and business intelligence.

Action#

Formatting - [Numbers] Format Number on Pipedream Utils

Description:Format a number to a new style. Does not perform any rounding or padding of the number.

Version:0.0.6

Key:pipedream_utils-format-number

View on GitHub

Pipedream Utils Overview#

The Pipedream Utils app is a set of pre-built functions that streamline common tasks in your workflows. It acts like a Swiss Army knife for developers, providing essential tools such as format conversion, date manipulation, and text processing. By leveraging these functions, you can reduce the boilerplate code needed for routine operations, speeding up the development of intricate automations. The Helper Functions API can be a game changer when it comes to tasks like parsing dates in user-friendly formats, encoding and decoding data, or generating UUIDs, making them more efficient and less error-prone.

Action Code#

import { ConfigurationError } from "@pipedream/platform";
import formatNumber from "../../common/numbers/formatNumber.mjs";
import {
  DECIMAL_MARK_OPTIONS, FINAL_FORMAT_OPTIONS,
} from "../../common/numbers/numberFormattingOptions.mjs";
import pipedream_utils from "../../pipedream_utils.app.mjs";
export default {
  name: "Formatting - [Numbers] Format Number",
  description: "Format a number to a new style. Does not perform any rounding or padding of the number.",
  key: "pipedream_utils-format-number",
  version: "0.0.6",
  annotations: {
    destructiveHint: false,
    openWorldHint: false,
    readOnlyHint: false,
  },
  type: "action",
  props: {
    pipedream_utils,
    input: {
      label: "Input",
      description: "Number string you would like to format.",
      type: "string",
    },
    inputDecimalMark: {
      label: "Input Decimal Mark",
      description: "The character the input uses to denote the decimal/fractional portion of the number. Defaults to period `.`",
      type: "string",
      options: DECIMAL_MARK_OPTIONS,
      optional: true,
    },
    toFormat: {
      label: "Output Format",
      description: "The format the number will be converted to.",
      type: "string",
      options: FINAL_FORMAT_OPTIONS,
    },
  },
  async run({ $ }) {
    const {
      inputDecimalMark, toFormat,
    } = this;
    const input = this.input.toString();
    const decimalMark = inputDecimalMark ?? ".";
    const splitInput = input.split(decimalMark);
    if (splitInput.length > 2) {
      throw new ConfigurationError(`Input has more than one decimal mark (\`${decimalMark}\`). Check if the \`Input Decimal Mark\` prop is set correctly.`);
    }
    const [
      integer,
      decimal,
    ] = splitInput;
    const [
      groupChar,
      decimalChar,
    ] = toFormat.split("");
    const result = formatNumber(integer, decimal, groupChar, decimalChar);
    $.export("$summary", "Successfully formatted number");
    return result;
  },
};

Action Configuration#

This component may be configured based on the props defined in the component code. Pipedream automatically prompts for input values in the UI.

Label	Prop	Type	Description
Pipedream Utils	`pipedream_utils`	`app`	This component uses the Pipedream Utils app.
Input	`input`	`string`	Number string you would like to format.
Input Decimal Mark	`inputDecimalMark`	`string`	Select a value from the drop down menu:`{ "label": "comma", "value": "," }{ "label": "period", "value": "." }`
Output Format	`toFormat`	`string`	Select a value from the drop down menu:`{ "label": "Comma for grouping & period for decimal", "value": ",." }{ "label": "Period for grouping & comma for decimal", "value": ".," }{ "label": "Space for grouping & period for decimal", "value": " ." }{ "label": "Space for grouping & comma for decimal", "value": " ," }`