Databox and Microsoft Power BI Integration
Demonstration of how apps are integrated in WEXTL workflow builder[4]
Build analytics workflows between Databox 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 Databox and Microsoft Power BI
Detailed info you need to know about Databox and Microsoft Power BI integrations in WEXTL. Explore which modules apps support and how you connect them.
Databox

Business analytics platform for sending custom data, defining metrics and reading dashboards.[5]
Microsoft Power BI

Push datasets and refresh Power BI reports and workspaces from your workflows.[6]
How to connect Databox to Microsoft Power BI
Set up your Databox and Microsoft Power BI integration in 3 simple steps[2]. No coding required. Up to 10 minutes setup.
STEP 1
Connect Databox 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 Databox 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 Databox and Microsoft Power BI. Use filters or a JS custom code step in between. Everything is on the canvas.
How does the integration between Databox and Microsoft Power BI work in WEXTL?
WEXTL exposes actions and triggers for Databox 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.
Databox triggersMicrosoft Power BI actions
Databox modules
- Create a Data Source Opens a data source for custom data. Leave Time Zone empty for UTC, or use Account to create it under a specific account.
- Create a Dataset Defines a dataset inside a data source with a Schema of typed columns. Use Primary Key so rows with the same key replace each other.
- Create a Metric Builds a metric on a dataset from a Measure Column and a Date Column. Choose an Aggregation, split by Dimensions and limit rows through Filters.
- Create a User Adds a person by Email with a chosen Role. The owner role cannot be assigned.
- Create an Account Adds an account to your Databox organization. Give it a Website URL and use Managed By to assign the user who runs it.
- Delete a Connection Removes a saved link to an outside service from Databox.
- Delete a Data Source Deletes a data source, the container that holds datasets, from your Databox organization.
- Delete a Dataset Removes a dataset from its data source in Databox.
- Delete a Dataset Modification Removes the modification from a dataset, which brings back its original columns.
- Delete a Metric Removes a metric that was defined on a dataset in Databox.
- Delete a User Deletes a member of your Databox organization.
- Delete an Account Deletes an account from your Databox organization.
- Duplicate a Dataset Copies a dataset into a new one. Use Name to title the copy.
- Get a Connection Looks up a connection, showing its Integration Key, Status Info and Data Sources Count.
- Get a Data Source Returns a data source with its Integration Key, Timezone and Status Info.
- Get a Dataset Reads a dataset with its Type, Timezone and Verification Info.
- Get a Dataset Ingestion Looks up one data load into a dataset, with its Status, Duration, Summary and Errors.
- Get a Dataset Lineage Maps a dataset to its Parents and Children, so you see what feeds it and what depends on it.
- Get a Dataset Modification Reads the modification currently applied to a dataset, covering Filters, Formulas, Display Names, Order and Visibility.
- Get a Dataset Schema Lists the column Items of a dataset and its Primary Key.
- Get a Dataset Verification Tells whether a dataset Is Verified, and when and by whom through Verified At and Verified By.
- Get a Metric Fetches a metric with its Description, Dimensions and whether it Supports Drilldown.
- Get a Metric Lineage Shows the Parents and Children of a metric, meaning what it is built from and what it feeds.
- Get a Metric Verification Checks whether a metric Is Verified, with Verified At and Verified By.
- Get a Profile Returns the signed-in user with Email, Role and Organization.
- Get a User Fetches a user with Email, Role and whether the Is Email Verified flag is set.
- Get an Account Fetches an account with its Company Name, Website URL and who it is Managed By.
- Get an Integration Pulls an integration with its Key, Description and whether it Supports Datasets.
- Get Billing Details Reads the Plan Name, Plan Status and Billing Period of the subscription, with its Billing Email.
- Get Connection Permissions Shows who may use a connection through Access Level and Access List, and whether it is Shared With Accounts.
- Get Data Source Permissions Shows the Access Level of a data source and the Access List of users allowed in.
- Get Dataset Column Metadata Reads the descriptive metadata attached to each column of a dataset, as a list of Items.
- Get Dataset Ingestion Statistics Summarizes loads into a dataset with the Success Rate, Avg Success Duration and Daily Statistics.
- Get Dataset Metadata Returns the Description, Synonyms and Default Time Dimension of a dataset.
- Get Dataset Permissions Shows the Access Level of a dataset and the Access List of users with access.
- Get Dataset Sync Statistics Reports the Last Successful Update At time, Success Rate and Daily Statistics of dataset syncs.
- Get Metric Data Reads values of a metric between Date From and Date To, grouped by Granularity. Split with Dimensions or limit rows with Filters, and add Source ID when the metric ID lacks one.
- Get Metric Drilldown Data Pulls the underlying rows of a metric between Period From and Period To, using the Source ID of the metric. Sort with Sort By and Sort Order, and stop at Limit rows.
- Get Organization Usage Counts what the organization uses, with Users, Data Sources, Accounts and Ai Credits.
- Get the Organization Fetches the organization profile with Company Name, Address and Tax Number.
- List Accounts Pages through the accounts of your organization. Use Search to match a name, Sort By and Sort Order to arrange them, and Limit to stop early.
- List Activity Log Gives log entries listing the Action, User and Resource Type of each change. Narrow with Date From, Date To or Search, and stop at Limit.
- List Connections Lists saved links to outside services, with Integration Key and whether each is Shared With Accounts. Use Search to match names.
- List Countries Lists the countries Databox knows, each by its Name and Code.
- List Dashboard Metrics Collects the Datablocks of one dashboard, showing which metrics it displays.
- List Dashboards Retrieves dashboards with their Tags and Integration Keys. Use Search to find one by name.
- List Data Source Sync Frequencies Offers the Sync Interval choices of a data source, marking which Is Default and which Is Selected.
- List Data Sources Retrieves data sources. Filter with Connection or Search, order with Sort By and Sort Order, and use Limit to stop early.
- List Dataset Ingestions Lists the data loads into a dataset with Initiated At, Status and Initiated By, up to a Limit.
- List Dataset Modification Functions Lists formula functions usable in dataset modifications, with their Signature, Parameters and Example.
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 Databox 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 Databox and Microsoft Power BI.
References
List of sources used to gather information about the Databox and Microsoft Power BI integration.
- Databox and Microsoft Power BI integration source code, module specs and credentials implementation.
- Our Databox and Microsoft Power BI integration documentation, structured input and output parameters, scopes, and authentication methods.
- Official vendor API documentation for Databox 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.
- Databox 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 Databox and Microsoft Power BI integration page documentation. Used sources, the role of AI, and how the team validates the result.