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

Upload, clean, query and export large spreadsheets in Gigasheet.[5]
Microsoft Power BI

Push datasets and refresh Power BI reports and workspaces from your workflows.[6]
How to connect Gigasheet to Microsoft Power BI
Set up your Gigasheet and Microsoft Power BI integration in 3 simple steps[2]. No coding required. Up to 10 minutes setup.
STEP 1
Connect Gigasheet 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 Gigasheet 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 Gigasheet and Microsoft Power BI. Use filters or a JS custom code step in between. Everything is on the canvas.
How does the integration between Gigasheet and Microsoft Power BI work in WEXTL?
WEXTL exposes actions and triggers for Gigasheet 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.
Gigasheet triggersMicrosoft Power BI actions
Gigasheet modules
- Watch Callbacks Starts a workflow when Gigasheet calls its callback address after an upload or export finishes. Each call brings its Handle and Message.
- Add a Geolocation Looks up the geolocation of each IP address in a column. Uses one API call. Drawn from your plan.
- Add an Iterator Column Numbers the rows in a new column called Column Name. Use Filter Model to number only matching rows and Sort Model to number them in a chosen order. Takes one API call. Billed to your plan.
- Add Conditional Labels Builds a new column whose labels come from the Cases, written as a JSON list. Use Output Column to name it and Default Label for rows that match no case. Costs one API call. Deducted from your plan.
- Append Rows Adds rows to the bottom of a sheet from the Body (JSON). Use Append Rows by Column Name when your rows are keyed by column name. Uses one API call. Taken off your plan.
- Append Rows by Column Name Adds rows to the bottom of a sheet from the Body (JSON), keyed by column name. Bills one API call. Deducted from your plan.
- Append Rows from Another Sheet Copies every row of a Source Sheet onto the end of a Target Sheet. Turn on Add Unmatched Columns to keep columns only the source has, and Trim Column Names to ignore extra spaces in headings. Spends one API call. Drawn from your plan.
- Apply HTTP Enrichment Runs a custom HTTP enrichment over a sheet with the Request Settings. Follow the task with Get HTTP Enrichment Status. Draws one API call. Counted on your plan.
- Build an AI Formula Turns a plain-language Prompt into a Gigasheet formula for a sheet and returns the Formula text. Charges one API call. Drawn from your plan.
- Cancel an HTTP Enrichment Stops a custom HTTP enrichment that is still running. One API call each. Charged to your plan.
- Change Case Use Case to turn every value of a column into upper case, lower case, capitalized or proper case text. Takes one API call. Counted on your plan.
- Change Column Type Converts a column to the new Cast Type. Use Cast Format to add the format that goes with that type. Costs one API call. Billed to your plan.
- Chat with Sheet Assistant Sends a Message to the AI assistant attached to a sheet and gets its answer about that data. Spends one API call. Taken off your plan.
- Check a Formula Tests whether a Formula is valid for the sheet before you run it. Takes one API call. Billed to your plan.
- Check Combine Files Dry-runs a combine of the Sheets and returns every error found, without creating anything. Costs one API call. Deducted from your plan.
- Check Combine Files by Name Dry-runs a combine of the Sheets by column name and returns every error found, without creating anything. One API call each. Taken off your plan.
- Check Email Format Tests whether each value of the Email Column is a correctly formed address. Spends one API call. Counted on your plan.
- Check Federated Table Tests whether the Members can form a federated table before you create one. Add a File Name and Parent Folder to try the exact target. Uses one API call. Charged to your plan.
- Check Source Availability Reports whether a chosen Connector source can be reached right now, returning Is Available. Bills one API call. Billed to your plan.
- Clean Company Names Standardizes the company names held in a column using the Gigasheet cleaner. Draws one API call. Drawn from your plan.
- Combine Columns Joins the values of several Columns, in order, under a new heading called Name. Put Separator text between the values. Charges one API call. Taken off your plan.
- Combine Files Merges the Sheets in order into a new sheet. Use Folder to place it, In Place to combine into the first sheet, and Add Input File Name to add the source sheet name as a column. One API call each. Deducted from your plan.
- Combine Files by Name Merges several Sheets by matching column names into a sheet called New Sheet Name. Turn on Case Insensitive and Trim Column Names to match headings more loosely. Costs one API call. Counted on your plan.
- Copy a File Duplicates a sheet or folder under File Name. Use Folder to place the copy, Recursive to copy the content of a folder too, and Copy State to copy a sheet state of your choosing. Takes one API call. Drawn from your plan.
- Count Activity Totals the activity entries on a sheet. Narrow them by Actions, Categories, Users or a Query, and bound them with Start and End. Spends one API call. Charged to your plan.
- Count Duplicate Rows Reports how many rows repeat across the chosen Columns. Run it ahead of Delete Duplicate Rows to see the impact. Uses one API call. Deducted from your plan.
- Count Groups Gives the number of groups formed by the Group Columns, limited to rows that pass a Filter Model. Bills one API call. Counted on your plan.
- Count Rows Returns how many rows a sheet holds, or only the ones that satisfy a Filter Model. Gigasheet bills one API call for each count.
- Create a Blank Sheet Makes an empty sheet called File Name with a set number of Columns and Rows. Turn on Upload to Team to add it to the team library. Draws one API call. Taken off your plan.
- Create a Connection Registers a data connection for a Connector from the Parameters it needs. Charges one API call. Charged to your plan.
- Create a Connector Source Adds a source such as hubspot to a connector from its Parameters, plus a Code, Org or User if the source asks for them. Uses one API call. Billed to your plan.
- Create a Federated Table Builds one federated table called File Name from several sheets. Use Members to list them and Parent Folder to store the table in a folder. Costs one API call. Drawn from your plan.
- Create a File Entry Adds an entry called File Name to the library. Turn on Skip Type Inference to keep every column as text and Skip Notification to stop the email. Takes one API call. Taken off your plan.
- Create a Folder Adds a folder called Name to your Gigasheet files, inside a Parent Folder when one is set. Its Handle is returned. Each run costs one API call on your Gigasheet plan.
- Create a Linked Sheet from a View Creates a linked sheet from a View, called Name and filed under Parent Folder. The Handle of the new sheet is returned. Spends one API call. Deducted from your plan.
- Create a View Saves a view of a sheet under Name, taking its layout from the client state with the Client State ID. Bills one API call. Drawn from your plan.
- Create an Export Starts exporting a sheet using the Grid State filters, sort and grouping. Use Row Limit to export only the first rows, Records per File to split the output, and Callback URL to be told when it finishes. One API call each. Billed to your plan.
- Delete a Column Deletes the chosen Column of a sheet. Charges one API call. Deducted from your plan.
- Delete a Connector Source Removes a data source that was attached to a Connector. Takes one API call. Charged to your plan.
- Delete a Saved Filter Deletes a filter template saved in your account. Charges one API call. Billed to your plan.
- Delete a Sheet Removes a sheet or folder from your library. Turn on Recursive to delete a folder together with its contents. This cannot be undone. This uses up one API call too.
- Delete a View Deletes the chosen View from a sheet. One API call each. Drawn from your plan.
- Delete Assistant History Deletes the chat log of the sheet assistant for one sheet. Draws one API call. Charged to your plan.
- Delete Columns Removes several Columns from a sheet in one request. One API call each. Counted on your plan.
- Delete Columns by Name Deletes every heading listed under Column Names from a sheet. Costs one API call. Taken off your plan.
- Delete Duplicate Rows Removes every duplicate row across the Columns, leaving one row per set. Use Filter Model to limit which rows are considered and Sort Model to choose which row stays. Spends one API call. Billed to your plan.
- Delete Rows Removes the listed Rows from a sheet. This cannot be undone. Uses one API call. Counted on your plan.
- Delete Rows Matching Filter Deletes all rows that satisfy a Filter Model. This cannot be undone. Bills one API call. Taken off your plan.
- Delete Rows Not Matching Filter Removes every row that fails a Filter Model, leaving only the matches. This cannot be undone. Draws one API call. Deducted from your plan.
- Describe a Sheet Reads the details of one sheet, including its File Name, Owner, Parent Directory and File Rows.
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 Gigasheet 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 Gigasheet and Microsoft Power BI.
References
List of sources used to gather information about the Gigasheet and Microsoft Power BI integration.
- Gigasheet and Microsoft Power BI integration source code, module specs and credentials implementation.
- Our Gigasheet and Microsoft Power BI integration documentation, structured input and output parameters, scopes, and authentication methods.
- Official vendor API documentation for Gigasheet 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.
- Gigasheet 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 Gigasheet and Microsoft Power BI integration page documentation. Used sources, the role of AI, and how the team validates the result.