Power BI – Connection

Microsoft Power BI is a business analytics tool that helps organizations visualize and interpret their data. It allows users to create interactive reports, dashboards, and data visualizations from various data sources, making complex data easier to understand and analyze. With Power BI, businesses can track key metrics, uncover insights, and make informed decisions based on real-time data.

Integrating Power BI with Wiresk brings significant advantages. By combining the data automation and workflow management capabilities of Wiresk with Power BI’s powerful data visualization features, businesses can enhance their decision-making process.

This integration allows for easy access to up-to-date data insights, helping teams monitor performance, analyze trends, and make quick, data-driven decisions.

Connect Microsoft Power BI to Wiresk Copy Link

How to get the Tenant ID Copy Link

• On the MS Azure Portal, select Microsoft Entra ID.

On the Overview page, The Tenant ID is displayed.

Add application registration Copy Link

• On the bottom page of the overview page, select Add application registration.

• Give a name to the App, we will named it “Wiresk”.
• For the support account types, select “Accounts in any organizational directory (Any Microsoft Entra ID tenant – Multitenant)”.
• Enter the Redirect URI: Web | https://api.wiresk.com/api/auth/callback
• Then, click on Register button.

Get the App ID Copy Link

On your Wiresk app overview screen, your App ID and tenant ID are displayed.

How to get the App Secret Copy Link

From the step before, click on the link next to “client credentials” or on the left side bar menu “Certificates & Secrets”

1. Select New client secret.
2. Write the client’s description or name.
3. Select the client secret expiration period. It is strongly advised to set the maximum period which is 2 years. This will prevent you from having to renew it too quickly.
4. Click on Add button.

Set the API Permissions Copy Link

1. Select API permissions.
2. Click on add a permission.
3. Select the Microsoft app that you want to set permissions, in our case choose Power BI service.

1. Select Delegated permissions, you must:
   • Be assigned a role (Member, Contributor, Admin) in the target Power BI workspace.
   • Have permission to access or modify the datasets in that workspace.
2. Set the needed permissions, refer to the permissions list below.
3. Click on add permissions.

Optionally, repeat the same process to add permissions for other Microsoft apps.

Now that you have in hand the Tenant ID, the App ID, and the App Secret, lets create a Microsoft connection.

Create a Microsoft Connection Copy Link

There are two ways to connect your app to Wiresk:

• In “My apps” section, where you can manage your connections (select or create your group first to get access to this section, refer to the Group system ).
• While building your Flow, you can easily establish a connection to your app directly within the Flow builder. This can be done during the setup of either a Trigger or a Method.

In this guide, we will explain how to create a connection in “My apps” section, it is essentially the same as when creating it on-the-go.

• On your Wiresk’s Dashboard, select your Group.
• On the left panel, go to “My apps” and select
• Search the app name in the search field or select it in the apps list.

There are 2 types of connections available:

• Client Credentials connection
• OAuth connection

Connection by OAuth Copy Link

1. Give a name to your connection, here we will name it “Microsoft OAuth”
2. Select the OAuth connect tab
3. Enter your Tenant ID (Mandatory for work or school account) that you saved from How to get the Tenant ID
4. Enter your App ID from Get the App ID
5. Enter your App secret “value” from How to get the App Secret
6. Select Microsoft application for the authorization (don’t forget to set the API permissions for those applications):
   • Select a single Microsoft app for specific functionality, in our case, Microsoft Power BI.
   • Grant access to all Microsoft apps for this connection, allowing broader use of your account.
7. Click on Authorize button

You will be redirected to Microsoft “Pick an account” page.

• Select your connected account or choose another one.

• Then you will be asked to give permissions to Wiresk, click on Accept button and you will be redirected to Wiresk connection panel settings
• Save the connection.

Connection by Client credentials Copy Link

1. Name your connection, for example, “Microsoft Client Credentials”
2. Select Client Credentials connection type
3. Enter your Tenant ID that you saved from How to get the Tenant ID
4. Enter your App ID from Get the App ID
5. Enter your App secret “value” from How to get the App Secret
6. Create your Microsoft connection by clicking on the “Create” button.

Voila! Your Microsoft Power BI connections are ready. You can now use it to build your Flows.

Basic understanding of Flow creation Copy Link

Now that your app is linked to Wiresk, you’re ready to start building Flows.

Simple steps to create a Flow ↓

• Select your Group, then on the Flow management screen click on “Create Flow”.
• On the new screen, name the new Flow.

Add a Trigger that will start your Flow

Flows can be executed by multiple Triggers, depending on the desired workflow. For example, you could use scheduled Triggers with different recurrence rules alongside a Webhook Trigger for immediate, event-driven runs of the Flow. If you choose to “Run Once“, the Flow will execute using only one Trigger and its sample data.

• Click on the (+) button to open the Trigger settings side panel.
• On the settings side panel, click on the “+ Add” button.

• On the Trigger selection screen, search your app or select it from the list below the screen.

• Select your preferred Trigger on the next screen and customize its settings.

As mentioned in “How to connect your app to Wiresk” above, during your Trigger settings, you can create a new connection to your apps at this stage.

Add a Method that will execute a task

The Method will perform a specific task on a particular app or service you’ve connected to Wiresk like get info or send emails.

You can add at least 1 or multiple Methods for complex Flows (a maximum of 255 Methods).

• On the Flow builder, select the (+) plus button next the Trigger button.
• Search or scroll down to select the app that will perform a task.
• Configure the Methods settings, refer to it documentation in our Help Center.

Add Wiresk Tools to your Flow

If you want to build a complex Flow, Wiresk offers a selection of tools at your disposal. Refer to Wiresk’s Tools

To add Tools in your Flow, Follow the same step as adding the Methods.

• On the Flow builder screen, click on the plus button (+) then just click on the “Tool” tab and select the Tool that you want to add.

---

Triggers and Methods Settings Copy Link

When you configure a Trigger or Method in Wiresk, the settings panel lets you define how data is collected or sent, and the type of values you enter depends on the field.

Make sure you enter the right values so your Flow works the way you expect and gives the right results. If you need step-by-step details on setting up Microsoft Power BI, check the Triggers and Methods Settings documentation.