Klipfolio and Microsoft Power BI Integration

Demonstration of how apps are integrated in WEXTL workflow builder[4]

Build analytics workflows between Klipfolio and Microsoft Power BI on a visual canvas. Set up data fields sync between apps once and let data flow when events come automatically. Integration will work without code and your team will see the workflow inside WEXTL® builder.

  • 3-day trial
  • Cancel anytime
  • Up to 10 minutes quick set up
  • GDPR
  • Data Encryption
  • 2FA
  • Local Data Region

Learn about Klipfolio and Microsoft Power BI

Detailed info you need to know about Klipfolio and Microsoft Power BI integrations in WEXTL. Explore which modules apps support and how you connect them.

  • Klipfolio

    • Analytics
    • 44 searches
    • 82 actions

    Business dashboards: manage Klips, dashboards, data sources, users, groups and client accounts in Klipfolio.[5]

  • Microsoft Power BI

    • Analytics
    • 2 triggers
    • 63 searches
    • 53 actions

    Push datasets and refresh Power BI reports and workspaces from your workflows.[6]

How to connect Klipfolio to Microsoft Power BI

Set up your Klipfolio and Microsoft Power BI integration in 3 simple steps[2]. No coding required. Up to 10 minutes setup.

How does the integration between Klipfolio and Microsoft Power BI work in WEXTL?

WEXTL exposes actions and triggers for Klipfolio 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.

Microsoft Power BI triggersKlipfolio actions

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.

Klipfolio modules

  • Add a Default Dashboard to a Group Sets a dashboard as a default dashboard for a group. Use Visibility to set where it appears for group members, Position for its order in the group list and Can Edit to let members edit it.
  • Add a Group to a User Puts a user in a group, with the user as the starting point. Use Can Edit to allow the user to edit the group.
  • Add a Klip to a Dashboard Places one or more Klips on a dashboard and reports the Klip Instances that were created for them.
  • Add a User to a Group Puts a user into a group from the group side and returns Success with the ID.
  • Add a User to a Role Gives a user the permissions of a role by enrolling them, from the role side.
  • Add Dashboards to a User Gives a user several dashboards in one call and returns the Tab Instances it created. Pass dashboards rather than dashboard instances.
  • Assign a Role to a User Assigns a role to a user, working from the user record, so that the user gets the permissions of that role.
  • Create a Client Creates a client account with a Name, Description and Status. Use Seats to set the number of seats instead of the default and External ID to store your own ID for the client.
  • Create a Dashboard Creates a dashboard with a Name and an optional Description, then returns its ID and Location.
  • Create a Data Source Sets up a data source that fetches its data through a Connector. Use Refresh Interval to set the seconds between refreshes, where 0 means no automatic refresh, and Properties to pass the connector properties as JSON.
  • Create a Data Source Instance Creates an instance, which holds the data, for a data source. Use Skip Refresh when you plan to push data to the instance yourself.
  • Create a Group Makes a group with a Name and an optional Description. Returns its ID and Location.
  • Create a Klip Makes a Klip called Name. Use Schema to define its content right away, taking a schema from Get a Klip Schema.
  • Create a Klip Annotation Writes an annotation on a Klip from the Annotation Text. Returns its Body, creator and Date Created.
  • Create a Published Link Publishes a dashboard as a link under a Name. Use Password to protect it, Theme and Logo URL to style it and Publicly Searchable to let search engines find it.
  • Create a Role Creates a named set of permissions. Use Permissions to choose what holders of the role may do.
  • Create a User Registers a person as a Klipfolio user, with First Name, Last Name, Email and Roles. Use Send Welcome Email to invite the user and Password to set one directly.
  • Delete a Client Deletes a client account and reports Success with its ID.
  • Delete a Client Property Deletes one custom property of a client. Partner accounts can set Client Account to act inside another client account.
  • Delete a Dashboard Deletes a dashboard out of your Klipfolio account.
  • Delete a Data Source Deletes a data source from Klipfolio. Use Client Account to act inside a client account of a partner account.
  • Delete a Data Source Instance Deletes one data source instance from Klipfolio and returns Success with its ID.
  • Delete a Data Source Instance Property Removes a custom property from one data source instance.
  • Delete a Data Source Property Clears one custom property off a data source and reports Success.
  • Delete a Group Deletes a group from your Klipfolio account and reports Success.
  • Delete a Klip Removes a Klip out of your Klipfolio account.
  • Delete a Klip Annotation Strikes an annotation from a Klip and reports Success with its ID.
  • Delete a Published Link Removes a published link of a dashboard from Klipfolio.
  • Delete a Role Deletes a named set of permissions from your Klipfolio setup.
  • Delete a Role Permission Revokes one Permission of a role, which is then reported as Success.
  • Delete a User Removes a user from your Klipfolio account, reporting Success and the ID.
  • Delete a User Property Removes a custom property from a user and reports Success.
  • Delete Data Source Instances Removes instances of a data source that have not been accessed since a cut-off date in UTC. Use Keep Latest Instance to keep the one accessed most recently.
  • Disable a Data Source Disables a data source in Klipfolio and returns the Operation that ran.
  • Enable a Data Source Switches a data source on in Klipfolio and reports the Operation that ran.
  • Extend a Client Trial Lengthens the trial of a client. Use Days to set how many extra days to grant.
  • Get a Client Retrieves a client account, covering its Name, Description, Status and Seats. Use Include Associations to also return users, groups and share rights.
  • Get a Dashboard Shows a dashboard along with its Name, Description and the user it was Created By. Use Include Associations to also return the Klip instances and share rights.
  • Get a Dashboard Layout Gets how the Klips of a dashboard are laid out, as a layout Type and a State.
  • Get a Data Source Loads one data source with its Connector, Name and Description.
  • Get a Data Source Instance Looks up a data source instance with its Datasource Name, Date Last Refresh and Date Next Refresh.
  • Get a Group Returns a group with its Name, Description and External ID. Use Include Associations to also return the members.
  • Get a Group Default Dashboard Gets one default dashboard of a group, with its Tab Name, Visibility and whether the group Can Edit it.
  • Get a Klip Gets one Klip with its Created By, Date Created and Description. Use Include Associations to also return the share rights.
  • Get a Klip Annotation Retrieves one annotation of a Klip, including its Body and Date Created.
  • Get a Klip Schema Gets the Schema of a Klip as JSON, ready to read or reuse in Update a Klip Schema.
  • Get a Profile Looks up the profile of the user that owns the credential, including First Name, Last Name and Email. Use Include Associations to also return tab instances, dashboard properties and permissions.
  • Get a Role Loads a role with its Name and Description. Use Include Associations to also return its users and permissions.
  • Get a User Returns one user with First Name, Last Name and Email. Use Include Associations to also return dashboards, groups, roles and properties.
  • Get Client Features Lists the features of one client, each with a Display Name and an Enabled flag.

Explore alternative integrations

There are other apps[9] supported by WEXTL that can be paired with Klipfolio and Microsoft Power BI integrations. Pick any from the list below if the current combination isn't the one you need.

Automate Klipfolio and Microsoft Power BI on WEXTL®

Claim your 3-day trial to build Klipfolio with Microsoft Power BI integration and access every WEXTL® feature.

Cancel anytime.

Frequently asked questions

Common questions about connecting Klipfolio and Microsoft Power BI.

How do I connect Klipfolio and Microsoft Power BI?

Connect your Klipfolio and Microsoft Power BI accounts once, pick a trigger in one app and an action in the other, then map the fields so data flows automatically between them.[3]

What can I automate between Klipfolio and Microsoft Power BI?

Example: when the "Watch Imports" trigger in Microsoft Power BI fires, WEXTL can "Add a Default Dashboard to a Group" in Klipfolio. Klipfolio has 126 actions (including Add a Default Dashboard to a Group, Add a Group to a User, and Add a Klip to a Dashboard). Microsoft Power BI has 116 actions (including Add a Group User, Add Dataset Rows, and Add Dataset Rows in a Group). Add filters and transforms between steps when you need them.[1]

Can Klipfolio trigger actions in Microsoft Power BI, and Microsoft Power BI in Klipfolio?

Yes. The integration works in both directions. Use the triggers of each app to start a workflow and the actions of the other app to update it.[2]

Do I need to write code to integrate Klipfolio and Microsoft Power BI?

No. Klipfolio-to-Microsoft Power BI automations are built visually on the canvas. You can optionally add custom JavaScript with Functions when you need advanced logic.[4]

Does Klipfolio integrate with Microsoft Power BI in real time?

Yes. Trigger-based automations start the moment Klipfolio (or Microsoft Power BI) fires a new event. Webhook-backed apps run within seconds, and polling-only apps re-check on a schedule you control.[7]

How long does it take to set up a Klipfolio + Microsoft Power BI integration?

A first automation typically takes 5–10 minutes: connect the credential of each app once, drop a trigger + action onto the canvas, map the fields, and turn the workflow on.

Do I need a paid plan to connect Klipfolio with Microsoft Power BI?

You can build your Klipfolio + Microsoft Power BI automation on a 3-day trial with every feature unlocked. Cancel anytime.[8]

References

List of sources used to gather information about the Klipfolio and Microsoft Power BI integration.

  1. Klipfolio and Microsoft Power BI integration source code, module specs and credentials implementation.
  2. Our Klipfolio and Microsoft Power BI integration documentation, structured input and output parameters, scopes, and authentication methods.
  3. Official vendor API documentation for Klipfolio and Microsoft Power BI, used to verify field meanings, authentication flows, and anything our own specs don't fully capture.
  4. WEXTL® visual workflow builder, anonymized data from our technical support team.
  5. Klipfolio integration information
  6. Microsoft Power BI integration information
  7. WEXTL® Scheduling
  8. WEXTL® Pricing and Trial
  9. WEXTL® Apps Library

How we write our apps documentation

Explore how WEXTL® crafted Klipfolio and Microsoft Power BI integration page documentation. Used sources, the role of AI, and how the team validates the result.

Explore Klipfolio and Microsoft Power BI, or get started