Available actions
Actions are what Albato performs when your automation is running, Actions also allow you to transfer data to other apps and systems.
Insert rows
Before setting up integrations with Power BI connect the app to Albato. To do this, go to the Apps section and click the Add a connection button. Select the app and click the Add a connection button.
Come up with a name for the connection or leave the one that Albato suggests by default. Also, to connect, you will need to fill in the fields Application directory ID, App client ID and App client secret of the service. To complete this task, you must use the values from your Power BI app or create a new one. We will explain how to accomplish this and find the required values.
Create an application for Power BI API
To create an application to work with Power BI Rest API, you need to go to portal.azure.com and select Portal settings (gear icon) in the upper right corner.
On the page that opens, go to the Directories + Subscriptions tab, copy the Directory ID. You will need this value later.
After that, follow this link and create a new registration.
Next, specify the Application Name and select an account type. Select Only in this organization directory or another value, depending on your needs.
To finish creating the application, you should click the Register button at the bottom of the page. If you don't make any mistakes filling out the form, the application will be created. Afterward, we will require the Application ID on the next page, so save it somewhere for our connection.
Specify this URL in the redirect URI field: https://r.albato.com/oauth/back/state
After clicking Register, you will see the Application ID and its catalog. Copy these parameters, they are the ones you need for the fields in the Albato personal cabinet.
Application (client) ID is for the App client ID field and Directory (tenant) ID for the Application directory ID field.
The next step is to grant permissions to work with the API. From the menu on the left, select API Permissions and click Add Permission.
In the Interfaces list of Microsoft APIs, find Power BI Service.
We, for this example, do not plan to perform authorization to access the Power BI Rest API, so we select Delegated permissions.
Next you need to add application permissions (insert and check the permissions checkbox):
Dataset.ReadWrite.All
Gateway.Read.All
Pipeline.Read.All
Workspace.Read.All
Complete the setup by clicking the Add Permissions button at the bottom of the page.
The newly added permission will appear in the list of configured permissions. We get a notification that our application has all the necessary permissions to work with Power BI API.
There is one final step to complete the application setup - getting the Client secret to work. Go to the application menu and select Certificates and Secrets, then choose New Client secret.
Include a description and expiration date.
Click Add, a new entry will appear in the list of secrets. Copy the value, go to your Albato account and paste it into the App client secret field of the service.
The application is ready, but without the next step you will not be able to connect and work with data. You need to go to the Admin portal in Power BI Service, find the following option in the list and activate the work options in it.
Go back to the Albato account and fill in the fields:
Directory (tenant) ID for the Application catalog ID
Application (client) ID is for the App client ID
Value of Secrets client for the App client secret
Click the Continue button.