Set up a connection to PowerBI

Tom Santiago
  • Updated

PowerBI documentation: API guide, Authentication, dataset limitations 

A. Set up a PowerBI connection

Start establishing a PowerBI connection in either of the following ways:

  • From the Resources menu, select Connections. Then, click + Create connection at the top right.
        – or –
  • While working in a new or existing integration, you can add an application to a flow simply by clicking Add source or Add destination/lookup.

In the resulting Application list, select PowerBI.

PowerBICon1.png

B. Provide PowerBI application details

The Create connection pane opens with required and advanced settings.

PowerBICreateCon.png

Name (required): Provide a clear and distinguishable name. Throughout integrator.io imports and exports, you will have the option to choose this new connection, and a unique identifier will prove helpful later when selecting among a list of connections that you’ve created.

Application (required, non-editable): A reminder of the app you’re editing. 

Admin user: Check this box if you are the PowerBI service administrator. This role can be assigned to users who need access to the PowerBI Admin Portal without also granting them other Office 365 administrative privileges.

C. Edit advanced PagerDuty Events settings

Before continuing, you have the opportunity to provide additional configuration information, if needed, for the PagerDuty Events connection.

Borrow concurrency from (optional): Select another connection from the list....

NOTE: Selecting another app changes form...

Concurrency level (optional): Up to 25 allowed....

D. Test the connection

  1. Click Save & authorize. The following page displays:

  1. Enter your registered email address.

  1. Enter the password of your registered PowerBI account.

  1. Click Accept to create the connection.
NOTE: Power BI refresh tokens expire after 90 days when not being used actively. If there is no flow configured or the connection has not been used in 90 days, you must refresh the token. 
Read more about this connector:

Related articles

Comments

2 comments

Date Votes
  • Dane Christian Belarmino

    So after the integration between power bi and another data source, will celigo provide some sort of an online database power bi desktop can connect to? I dont see any celigo connector in power bi desktop.

    0
  • Adel Haider Solutions Engineer
    Top Contributor
    Celigo University Level 3: Master

    Hi Dane Christian Belarmino

    Thank-you for your question.

    Celigo acts purely as the middleware platform to ingest/transfer and manipulate the data between systems. We do not provide a database that PowerBI desktop can connect to.

    I advise looking into setting up a proper BI solution architecture for your data-driven needs.

    0

Please sign in to leave a comment.