Specifics of Using Precoro Power BI Connector for Multi-Сompanies

Learn how to set up the Power BI connector for multiple companies, schedule automated data refresh, and retrieve data from each company to Power BI simultaneously for an easy reporting process.

TABLE OF CONTENTS: 

How to Set Up the Power BI Connector for Multiple Companies

To connect to the first company, follow the steps outlined in the How to Set Up the Power BI Custom Connector guide. Make sure to remember the company name you used during authentication in Step 4.

To add the second company:

  1. Retrieve the API token.
  2. Go to the Power BI Desktop → Get Data → More (…) → launch the Precoro API connector again.
  3. In the connector window, enter the new company name. Power BI will save the credentials for the company under the entered name, so save it for future reference.
  4. Enter the email you use to log in to your company account and the relevant API token to complete the login.

Repeat these steps to connect additional companies.

💡Please note: When working with data loading or transformation in Power BI Desktop, you can switch between companies using the Recent Sources menu.

Recent Sources-1

How to Schedule a Data Refresh for Multiple Companies

Follow the steps in How to Set Up a Scheduled Refresh for Power BI, with the only variation occurring during the credential setup process (Step 3). Below are the details based on your chosen gateway mode.

Option 1: On-premises Data Gateway (Standard Mode)

If using the standard mode, you need to configure a data source for each connected company manually:

  1. Click the Manually add to gateway link to add data sources for each company.
  2. Configure each data source following the same process as for a single company.
  3. Map the data sources → click Apply.

Once completed, proceed to Step 4 to finalize the scheduled refresh setup.

Option 2: On-premises Data Gateway (Personal Mode)

For the personal mode, you should provide credentials for each company in the Data source credentials section:

  1. When prompted, enter the credentials for the specified company in the pop-up window.
    Configure Multi-Companies
  2. Repeat this process for all connected companies.
  3. A success message will appear in the top-right corner once all credentials are entered. Success Message 1

Once done, move to Step 4  to complete the scheduled refresh setup.