Microsoft Power BI – Connection

Connect Microsoft Power BI to Wiresk 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 documentation, we will explain how to create a connection in “My apps” section, it is essentially the same as when creating it on-the-go.

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
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

• 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 Microsoft Power BI 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”.

Select the Trigger

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.

• On the new screen, name the Flow that you want to create.
• Add your Triggers by clicking on the next to “All Triggers”.
• 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. Refer to Microsoft Power BI Triggers 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 to your Flow

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 screen, click on the plus button (+) next to the Trigger icon.

• Search or scroll down to select your apps Methods, then configure it settings. Refer to Microsoft Power BI Methods settings.

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

Configure Microsoft Power BI Triggers and Methods by Exploring the settings.