--- title: Specifics of Using Precoro Power BI Connector for Multi-Сompanies description: Learn how to configure the Precoro Power BI connector for multiple companies, set up scheduled data refresh, and optimize reporting. --- [Skip to content](https://help.precoro.com/specifics-of-using-precoro-power-bi-connector-for-multi-companies-1#main-content) [Contact us](https://help.precoro.com/kb-tickets/new?hsLang=en) [Customer portal](https://help.precoro.com/tickets-view?hsLang=en) [![Property 1=Default](https://help.precoro.com/hubfs/Property%201=Default.svg)](https://app.precoro.com/login) Open main navigation Close main navigation - [Contact us](https://help.precoro.com/kb-tickets/new) - [Customer portal](https://help.precoro.com/tickets-view) - [Contact Us](https://share.hsforms.com/1-5JilMA_Qv6AOSVjFtNhDg14slf) [Contact Us](https://share.hsforms.com/1-5JilMA_Qv6AOSVjFtNhDg14slf) Hi there! How can we help you today? - There are no suggestions because the search field is empty. 1. [Knowledge Base](https://help.precoro.com/?hsLang=en) 2. [Precoro Integrations](https://help.precoro.com/precoro-integrations?hsLang=en) 3. [Power BI](https://help.precoro.com/precoro-integrations?hsLang=en#power-bi) # 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](https://help.precoro.com/specifics-of-using-precoro-power-bi-connector-for-multi-companies-1#how-to-set-up) - [How to Schedule a Data Refresh for Multiple Companies](https://help.precoro.com/specifics-of-using-precoro-power-bi-connector-for-multi-companies-1#how-to-schedule) - [Option 1: On-premises Data Gateway (Standard Mode)](https://help.precoro.com/specifics-of-using-precoro-power-bi-connector-for-multi-companies-1#option-1) - [Option 2: On-premises Data Gateway (Personal Mode)](https://help.precoro.com/specifics-of-using-precoro-power-bi-connector-for-multi-companies-1#option-2) ### 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**](https://help.precoro.com/how-to-set-up-the-power-bi-custom-connector-1?hsLang=en) 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](https://app.precoro.com/manage/user/apitokens). 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](https://help.precoro.com/hs-fs/hubfs/Recent%20Sources-1.png?width=670&height=356&name=Recent%20Sources-1.png)](https://help.precoro.com/hubfs/Recent%20Sources-1.png?hsLang=en) ### How to Schedule a Data Refresh for Multiple Companies Follow the steps in [**How to Set Up a Scheduled Refresh for Power BI**](https://help.precoro.com/how-to-set-up-a-scheduled-refresh-for-power-bi-1?hsLang=en), with the only variation occurring during the credential setup process ([Step 3](https://help.precoro.com/how-to-set-up-a-scheduled-refresh-for-power-bi-1?hsLang=en#step3)). 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](https://help.precoro.com/how-to-set-up-a-scheduled-refresh-for-power-bi-1?hsLang=en#step4) 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](https://help.precoro.com/hs-fs/hubfs/Configure%20Multi-Companies.png?width=670&height=352&name=Configure%20Multi-Companies.png)](https://help.precoro.com/hubfs/Configure%20Multi-Companies.png?hsLang=en) 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](https://help.precoro.com/hs-fs/hubfs/Success%20Message%201.png?width=670&height=352&name=Success%20Message%201.png)](https://help.precoro.com/hubfs/Success%20Message%201.png?hsLang=en) Once done, move to [Step 4](https://help.precoro.com/how-to-set-up-a-scheduled-refresh-for-power-bi-1?hsLang=en#step4)  to complete the scheduled refresh setup. - [Precoro Setup](https://help.precoro.com/precoro-setup?hsLang=en#main-content) - [Configurations](https://help.precoro.com/precoro-setup?hsLang=en#configurations) - [User Management](https://help.precoro.com/precoro-setup?hsLang=en#user-management) - [Custom Fields and Forms](https://help.precoro.com/precoro-setup?hsLang=en#custom-fields-and-forms) - [Supplier management](https://help.precoro.com/precoro-setup?hsLang=en#supplier-management) - [Working with Items](https://help.precoro.com/precoro-setup?hsLang=en#working-with-items) - [Approval Workflow](https://help.precoro.com/precoro-setup?hsLang=en#approval-workflow) - [Location Management](https://help.precoro.com/precoro-setup?hsLang=en#location-management) - [Precoro Payments](https://help.precoro.com/precoro-setup?hsLang=en#precoro-payments) - [Two-factor authentication](https://help.precoro.com/precoro-setup?hsLang=en#two-factor-authentication) - [Security](https://help.precoro.com/precoro-setup?hsLang=en#security) - [US Based Server](https://help.precoro.com/precoro-setup?hsLang=en#us-based-server) - [How to use Precoro](https://help.precoro.com/how-to-use-precoro?hsLang=en#main-content) - [Warehouse Requests](https://help.precoro.com/how-to-use-precoro?hsLang=en#warehouse-requests) - [Requests for Proposals](https://help.precoro.com/how-to-use-precoro?hsLang=en#requests-for-proposals) - [Purchase Requisitions](https://help.precoro.com/how-to-use-precoro?hsLang=en#purchase-requisitions) - [Purchase Orders](https://help.precoro.com/how-to-use-precoro?hsLang=en#purchase-orders) - [Service Orders](https://help.precoro.com/how-to-use-precoro?hsLang=en#service-orders) - [Receipts](https://help.precoro.com/how-to-use-precoro?hsLang=en#receipts) - [Invoices](https://help.precoro.com/how-to-use-precoro?hsLang=en#invoices) - [Expenses](https://help.precoro.com/how-to-use-precoro?hsLang=en#expenses) - [Budgeting](https://help.precoro.com/how-to-use-precoro?hsLang=en#budgeting) - [Inventory](https://help.precoro.com/how-to-use-precoro?hsLang=en#inventory) - [Reports](https://help.precoro.com/how-to-use-precoro?hsLang=en#reports) - [AP Inbox and Intelligent AP Automation](https://help.precoro.com/how-to-use-precoro?hsLang=en#ap-inbox-and-intelligent-ap-automation) - [Working with documents](https://help.precoro.com/how-to-use-precoro?hsLang=en#working-with-documents) - [Suppliers Portal](https://help.precoro.com/how-to-use-precoro?hsLang=en#suppliers-portal) - [Supplier Registration](https://help.precoro.com/how-to-use-precoro?hsLang=en#supplier-registration) - [Attachments, Filters, and Search](https://help.precoro.com/how-to-use-precoro?hsLang=en#attachments-filters-and-search) - [Mobile App](https://help.precoro.com/how-to-use-precoro?hsLang=en#mobile-app) - [FAQs and Troubleshooting](https://help.precoro.com/how-to-use-precoro?hsLang=en#faqs-and-troubleshooting) - [Precoro Integrations](https://help.precoro.com/precoro-integrations?hsLang=en#main-content) - [QuickBooks Online Integration](https://help.precoro.com/precoro-integrations?hsLang=en#quickbooks-online-integration) - [NetSuite Integration](https://help.precoro.com/precoro-integrations?hsLang=en#netsuite-integration) - [Xero Integration](https://help.precoro.com/precoro-integrations?hsLang=en#xero-integration) - [API Requests and Webhooks](https://help.precoro.com/precoro-integrations?hsLang=en#api-requests-and-webhooks) - [SSO Setting](https://help.precoro.com/precoro-integrations?hsLang=en#sso-setting) - [Google Integration](https://help.precoro.com/precoro-integrations?hsLang=en#google-integration) - [Power BI](https://help.precoro.com/precoro-integrations?hsLang=en#power-bi) - [Integration with Slack](https://help.precoro.com/precoro-integrations?hsLang=en#integration-with-slack) - [PunchOut Catalogs](https://help.precoro.com/precoro-integrations?hsLang=en#punchout-catalogs) - [Integrations via Connectors](https://help.precoro.com/precoro-integrations?hsLang=en#integrations-via-connectors) - [Bill.com Integration](https://help.precoro.com/precoro-integrations?hsLang=en#bill-com-integration) - [Precoro Updates](https://help.precoro.com/precoro-updates?hsLang=en#main-content) - [Releases, 2026](https://help.precoro.com/precoro-updates?hsLang=en#releases-2026) - [Releases, 2025](https://help.precoro.com/precoro-updates?hsLang=en#releases-2025) - [Releases, 2024](https://help.precoro.com/precoro-updates?hsLang=en#releases-2024) - [Releases, 2023](https://help.precoro.com/precoro-updates?hsLang=en#releases-2023) - [API Updates](https://help.precoro.com/precoro-updates?hsLang=en#api-updates) - [General changes](https://help.precoro.com/precoro-updates?hsLang=en#general-changes) [![Precoro](https://help.precoro.com/hubfs/Precoro.svg "Precoro")](https://precoro.com/) Copyright © 2026, Precoro