with Microsoft Power BI and Pipedream Utils?
Emits a new event when a dataset refresh operation has completed. See the documentation
Emits an event when a dataset refresh operation has failed in Power BI. See the documentation
Emit new event when a new dataset refresh operation is created. See the documentation
Adds new data rows to the specified table within the specified dataset from My workspace. See the documentation
Get memory usage statistics for the current Pipedream workflow.
Cancels a refresh operation for a specified dataset in Power BI. See the documentation
Convert an object to a JSON format string
Creates a new Push Dataset in Power BI. See the documentation
Add or subtract time from a given input
Get the duration between two dates in days, hours, minutes, and seconds along with checking if they are the same.
Triggers a refresh operation for a specified Power BI dataset. See the documentation
Format a date string to another date string. For more examples on formatting, see the Sugar Date Format documentation.
Get reports from a Power BI workspace. See the documentation
Format a number to a new style. Does not perform any rounding or padding of the number.
Triggers a refresh operation for a specified Power BI dataset. See the documentation
Convert valid HTML to Markdown text
Convert Markdown text to HTML
Find a match for a regular expression pattern. Returns all matched groups with start and end position.
Find matches for regular expressions. Returns all matched groups with start and end position.
Find an email address out of a text field. Finds the first email address only.
Find a number out of a text field. Finds the first number only.
Find a complete phone number out of a text field. Finds the first number only.
Find a web URL out of a text field. Finds the first URL only.
Replace all instances of any character, word or phrase in the text with another character, word or phrase.
Return a default value if the text is empty
Split the text on a character or word and return one or all segments
Removes leading and trailing whitespace
Accepts a base64-encoded string, returns a decoded UTF-8 string
Get the difference, intersection, union, or symetric difference of two arrays/sets.
Convert an amount between currencies. See the documentation
Converts an HTML string to the Slack mrkdwn format using
Accepts a JavaScript object, returns that object converted to a JSON string
Return the country name (in English) when given the 2-letter country code
Convert a CSV file to an array of objects.
Downloads a file to your workflow's /tmp directory
Export variables for use in your workflow
Use the moment.js npm package to format an ISO8601 date/time as Google Sheets friendly formats. This action exports an object with compound date/time, date-only, and time-only values.
Returns the current time, tied to this workflow invocation, in the target timezone
Returns an ISO string (UTC TZ) N days ago
Given an ISO 8601 timestamp, and a timezone, convert the time to the target timezone.
Pretty print a JavaScript object or value
Generate a random integer (whole number). Useful for random delays.
Returns a randomly selected value(s) from a user-defined list of options.
Retrieve all stories from one or more RSS feeds.
Gets new stories from a specified RSS feed that have not already been processed.
Sends an email using the nodemailer package
Send data to Amazon S3 using Pipedream's destination integration. See https://docs.pipedream.com/destinations/s3/
Trigger another Pipedream workflow in your workspace.
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.
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}`, }, }) }, }) 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.
export default defineComponent({ props: { pipedream_utils: { type: "app", app: "pipedream_utils", } }, async run({steps, $}) { }, })