Faraday and Microsoft Power BI Integration
Demonstration of how apps are integrated in WEXTL workflow builder[4]
Connect Faraday and Microsoft Power BI to automate analytics workflows. Trigger events from one app, run actions in the other and use AI to make smart decisions. Integrate apps in 3 simple steps - no code required.
- 3-day trial
- Cancel anytime
- Up to 10 minutes quick set up
- GDPR
- Data Encryption
- 2FA
- Local Data Region
Learn about Faraday and Microsoft Power BI
Detailed info you need to know about Faraday and Microsoft Power BI integrations in WEXTL. Explore which modules apps support and how you connect them.
Faraday

Predictive analytics that forecasts customer behavior from your data.[5]
Microsoft Power BI

Push datasets and refresh Power BI reports and workspaces from your workflows.[6]
How to connect Faraday to Microsoft Power BI
Set up your Faraday and Microsoft Power BI integration in 3 simple steps[2]. No coding required. Up to 10 minutes setup.
STEP 1
Connect Faraday and Microsoft Power BI
Save credentials in WEXTL once. We store them encrypted and reuse the authorization across every workflow[3]. No coding or API skills required.
STEP 2
Build a workflow
Paste selected Faraday and Microsoft Power BI nodes onto the canvas[4], or describe what you want and WEXTL wires the flow together with AI Builder.
STEP 3
Map your data
Choose which fields need to sync between Faraday and Microsoft Power BI. Use filters or a JS custom code step in between. Everything is on the canvas.
How does the integration between Faraday and Microsoft Power BI work in WEXTL?
WEXTL exposes actions and triggers for Faraday and Microsoft Power BI that help you connect apps and automate repetitive tasks[1]. A trigger is an event that happens, and an action is a step that performs when the event has occurred.
Faraday triggersMicrosoft Power BI actions
Faraday modules
- Watch Events Runs the workflow the moment Faraday sends a webhook event, passing its Type, Timestamp, Account ID, Resource Type and Resource ID.
- Add an Upload Stores the content of File in your Faraday uploads, such as a CSV, and returns the Subpath and Size of the new upload.
- Archive a Cohort Marks a cohort as archived and returns its Status. Use Cascade To to list dependent resource IDs that go into the archive with it.
- Archive a Connection Archives a connection to outside data and returns its Created at time.
- Archive a Dataset Puts a dataset into the archive. Use Cascade to All to include everything that depends on it.
- Archive a Forecast Archives a forecast and returns its ID, Name and Status.
- Archive a Persona Set Marks a persona set as archived. The reply shows its Name and Status.
- Archive a Recommender Files a recommender in the archive. Use Cascade to All to bring its dependent resources along.
- Archive a Scope Archives a scope. The Created at time is returned.
- Archive a Stream Puts a data stream into the archive. The Status of the stream is returned.
- Archive a Target Archives a target. Use Cascade To to list the dependent IDs that should be archived alongside it.
- Archive a Trait Archives a trait, returning its Name together with its Account id.
- Archive an Atlas Archives an atlas. Use Cascade to All to also archive the resources that depend on it, or Cascade To to name the dependent IDs.
- Archive an Outcome Sets an outcome aside in the archive. Use Cascade To to list the dependent IDs that should be archived in the same step.
- Create a Cohort Defines a cohort of people from Stream Conditions (JSON), Place Conditions (JSON), Location Conditions (JSON), Traits (JSON) or Attributes (JSON).
- Create a Connection Saves access to an outside data system with a Name and its Options (JSON), for use by datasets, atlases and targets.
- Create a Dataset Defines a dataset from Identity Sets (JSON) and Options (JSON), reading through a Connection when one is set. Use Output to Streams (JSON) or Output to Traits (JSON) to send records on and Privacy to pick Suppress or Delete for data handling.
- Create a Forecast Defines a forecast on a Stream and Stream Property Name, entered through an Entry Stream with a Horizon (JSON). Use Eligible Cohort, Predictors (JSON) or Currency to refine it.
- Create a Persona Set Splits the people of a Cohort into personas. Set Number of Clusters to control how many groups form and Clustering Dimensions (JSON) to choose what they split on.
- Create a Recommender Builds a recommender on a Stream and its Stream Property Name, with Predictors (JSON) and an optional Preview.
- Create a Scope Defines a scope from a Population (JSON) listing its cohorts and a Payload (JSON) listing attributes and outcomes.
- Create a Target Adds a target for a Scope with a Representation (JSON) and Options (JSON). Narrow the output with Filter (JSON) and Limit Rows (JSON), and set a Connection to deliver it elsewhere.
- Create a Trait Creates a trait. Use Readable Name for the friendlier name shown in reports, Statistical Type and Unit to describe it and Lookup Table (JSON) to map values.
- Create a Webhook Endpoint Subscribes a URL to the chosen Events, so Faraday sends a call there when they fire. The new endpoint comes with its Enabled events and Status.
- Create an Account Sets up a new Faraday account with a Name. Use Branding (JSON) to pass its branding settings as a JSON object.
- Create an Atlas Sets up an atlas using Options (JSON) for its source type and settings. Use Output to Locations (JSON) to map your columns to location fields and Connection to read from a data system.
- Create an Attribute Defines an attribute in a Feature Store, fed by the Value Property Name of a Stream. Use Readable Name for the friendlier name shown in reports, Category and Tier to classify it and Statistical Type or Unit to describe its values.
- Create an Outcome Defines an outcome from the Attainment Cohort of people who reached it. Use Feature Blocklist to leave features out by name, and Eligible Cohort, Attrition Cohort, Prediction Mode or Bias Mitigation (JSON) to refine it.
- Delete a Cohort Deletes a cohort definition made of stream, place and location conditions.
- Delete a Connection Removes a connection to an external data system.
- Delete a Dataset Deletes a dataset that reads its records through a connection.
- Delete a Forecast Removes a forecast that predicts from a stream over a horizon.
- Delete a Persona Set Removes a persona set that was clustered from a cohort.
- Delete a Recommender Deletes a recommender built on a stream.
- Delete a Scope Removes a scope, the population and payload definition that targets deliver.
- Delete a Stream Deletes a stream of records from Faraday.
- Delete a Target Removes a target defined on a scope.
- Delete a Trait Removes a trait that holds a statistical type and unit.
- Delete a Webhook Endpoint Removes a webhook endpoint that receives Faraday events at a URL.
- Delete an Account Deletes an account from the Faraday platform.
- Delete an Atlas Deletes an atlas definition from Faraday.
- Delete an Attribute Removes an attribute from its feature store.
- Delete an Outcome Deletes an outcome defined by an attainment cohort.
- Delete an Upload Deletes a stored file from your Faraday uploads.
- Download a Target CSV Downloads the output of a target as a CSV file you can pass to other modules.
- Download an Upload Downloads a stored file from your Faraday uploads and returns it as a File.
- Find or Create a Stream Looks up a stream and creates it when none exists, returning its record either way.
- Force Update a Cohort Requests a fresh cohort build and reports the Cohort id.
- Force Update a Connection Starts another run of a connection and reports Success with its Connection id.
- Force Update a Dataset Rebuilds a dataset straight away and reports Success with the Dataset id.
Microsoft Power BI modules
- Add a Group User Gives a user, group or app access to a workspace. Use Group User Access Right to set the permission level and Principal Type for the kind of principal. Returns the ID.
- Add Dataset Rows Adds new rows to a named table of a dataset, using Dataset Rows for the values.
- Add Dataset Rows in a Group Appends rows to the table of a workspace dataset. Output includes Key and Value.
- Assign a Pipeline Workspace Attaches a workspace to a stage of a deployment pipeline. Use Stage Order to say which stage receives it.
- Assign a Workspace to a Capacity Places a workspace on a Power BI capacity. List Capacities shows which ones you can assign.
- Assign a Workspace to Dataflow Storage Assigns a workspace to a dataflow storage account. Use Dataflow Storage ID to pick the Power BI storage account that holds its dataflows.
- Bind a Dataset to a Gateway Binds a dataset to a data gateway. Use Datasource Object IDs to limit the binding to certain data sources, and List Dataset Gateways to see candidates.
- Bind a Dataset to a Gateway in a Group Binds a dataset from a workspace to a data gateway. Use Datasource Object IDs to narrow which of its data sources get bound.
- Cancel a Dataflow Transaction Cancels one transaction of a dataflow in a workspace. Output includes the Transaction ID and Status.
- Cancel a Dataset Refresh Stops a refresh of a dataset that is currently underway in Power BI.
- Cancel a Dataset Refresh in a Group Aborts a refresh that is still running on a dataset in a workspace.
- Clone a Tile Copies a dashboard tile onto another dashboard. Use Position Conflict Action to settle what happens when the spot is taken, and Target Report ID or Target Model ID to rebind the copy. Returns the new tile ID.
- Clone a Tile in a Group Duplicates a tile of a dashboard in a workspace. Add Target Workspace ID to send the copy to a different workspace. Output includes an Embed URL.
- Create a Dashboard Makes a dashboard under a new Name. Output includes its ID, Display name and Embed URL.
- Create a Dashboard in a Group Adds a dashboard to a workspace, with its Embed URL in the output.
- Create a Group Creates a new Power BI workspace from a Name. Output includes its ID, Name and Is read only.
- Create a Pipeline Creates a deployment pipeline under a Display Name. Add a Description to explain what it is for.
- Create a Profile Adds a service principal profile under a Display Name and returns its ID.
- Delete a Dataflow Removes a single dataflow from the Power BI workspace that holds it.
- Delete a Dataset Deletes an entire dataset from Power BI by its Dataset ID.
- Delete a Dataset in a Group Deletes one dataset that sits inside a Power BI workspace.
- Delete a Group Deletes a whole workspace from Power BI.
- Delete a Group User Removes a user from a workspace. Use User with an email address or a service principal object ID, and Profile ID for service profiles.
- Delete a Pipeline Removes one deployment pipeline from Power BI, found by Pipeline ID.
- Delete a Profile Deletes a service principal profile from Power BI.
- Delete a Workspace Dashboard Removes a dashboard from Power BI, identified by Dashboard ID.
- Delete a Workspace Dashboard in a Group Deletes one dashboard from a workspace, found by its Dashboard ID in the Power BI service.
- Delete Dataset Rows Deletes every row from one table of a dataset so that the table holds no data.
- Delete Dataset Rows in a Group Removes all rows of a table in a dataset that sits in a workspace.
- Deploy All Pipeline Content Deploys all content from one stage of a deployment pipeline. Turn on Is Backward Deployment to deploy from a later stage to an earlier one. Use New Workspace to create the target workspace and Note to describe the deployment.
- Deploy Chosen Items of a Pipeline Deploys only the chosen datasets, reports, dashboards, dataflows or datamarts from one pipeline stage. Use Note for a remark about the deployment.
- Execute DAX Queries Runs a DAX Query against a dataset. Use Effective Username to run it as a named user, Query Timeout and Memory Limit to cap its time and memory, and Result Set Row Count Limit to set the maximum number of rows.
- Execute DAX Queries in a Group Evaluates a DAX Query for a dataset of a specific workspace. Use Roles or Custom Data for Dynamic RLS, and Culture for locale-specific query formatting.
- Execute Queries Evaluates one or more Queries against a dataset and returns Results. Add an Impersonated User Name to run as another user.
- Execute Queries in a Group Runs a batch of queries against a dataset kept in a workspace. Output includes the Results. Use Include Nulls to keep null values in the serialized output.
- Export a Dataflow Downloads the definition of a dataflow as a file, delivered as File Data.
- Get a Dataset Query Scale Out Sync Status Reports how far the read-only replicas of a dataset have synchronised. Output includes Commit version, Target sync version, Trigger reason and Sync end time.
- Get a Dataset Query Scale Out Sync Status in a Group Reads the replica sync state of a dataset in a workspace, from Commit timestamp to Sync start time and Min active read version.
- Get a Direct Query Refresh Schedule Reads the refresh schedule of a DirectQuery dataset: its Days, Times and Local time zone ID.
- Get a Direct Query Refresh Schedule in a Group Looks up the DirectQuery refresh schedule for a dataset in a workspace, returning Days and Times.
- Get Dataset Refresh Details Shows how one dataset refresh went. Output lists the Status and Number of attempts, plus the Objects processed and timing.
- Get Dataset Refresh Details in a Group Inspects one refresh run of a workspace dataset. You see its Status, Extended status, Current refresh type and Commit mode.
- Get the Artifacts of a Pipeline Stage Shows what is in one stage of a deployment pipeline, grouped as Dataflows, Datamarts, Datasets, Reports and Dashboards.
- List App Dashboards Collects every dashboard that an app ships with. Each arrives with a Display name.
- List App Reports Fetches the reports that an app contains, each with Name, Web URL and Dataset ID.
- List App Tiles Retrieves the tiles on one app dashboard, each with its Title and Report ID.
- List Apps Returns the apps in your Power BI account as separate items, each with Name, Description and Published by.
- List Capacities Shows the capacities you can reach, with Display name, Sku, Region and State.
- List Capacity Refreshables Finds the items on one capacity that refresh, with Kind, Refresh count and Refresh failures. List Refreshables spans all capacities.
- List Dataflow Sources Lists the data sources a dataflow reads from, showing the Datasource type of each.
Explore alternative integrations
There are other apps[9] supported by WEXTL that can be paired with Faraday and Microsoft Power BI integrations. Pick any from the list below if the current combination isn't the one you need.
Frequently asked questions
Common questions about connecting Faraday and Microsoft Power BI.
References
List of sources used to gather information about the Faraday and Microsoft Power BI integration.
- Faraday and Microsoft Power BI integration source code, module specs and credentials implementation.
- Our Faraday and Microsoft Power BI integration documentation, structured input and output parameters, scopes, and authentication methods.
- Official vendor API documentation for Faraday and Microsoft Power BI, used to verify field meanings, authentication flows, and anything our own specs don't fully capture.
- WEXTL® visual workflow builder, anonymized data from our technical support team.
- Faraday integration information
- Microsoft Power BI integration information
- WEXTL® Scheduling
- WEXTL® Pricing and Trial
- WEXTL® Apps Library
How we write our apps documentation
Explore how WEXTL® crafted Faraday and Microsoft Power BI integration page documentation. Used sources, the role of AI, and how the team validates the result.