--- title: Getting Started with Power BI description: Connect Precoro to Power BI to analyze your procurement data and discover best practices for seamless and efficient synchronization. --- [Skip to content](https://help.precoro.com/getting-started-with-power-bi#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) # Getting Started with Power BI ## Learn how to use the Power BI integration to analyze your procurement data, simplify reporting, and make data-driven decisions with ease. #### TABLE OF CONTENTS - [What Is Power BI?](https://help.precoro.com/getting-started-with-power-bi#what-is) - [How Data Is Transferred from Precoro to Power BI](https://help.precoro.com/getting-started-with-power-bi#connectors) - [Power BI Custom Connector & Precoro API limits](https://help.precoro.com/getting-started-with-power-bi#limits) - [How to Ensure Successful Data Transfer](https://help.precoro.com/getting-started-with-power-bi#data-transfer) - [How to Connect Power BI and Precoro](https://help.precoro.com/getting-started-with-power-bi#how-to-connect) - [Step 1: Install the Connector](https://help.precoro.com/getting-started-with-power-bi#step-1) - [Step 2: Select the Necessary Data Tables and Filters](https://help.precoro.com/getting-started-with-power-bi#step-2) - [Step 3: Configure Incremental Refresh](https://help.precoro.com/getting-started-with-power-bi#step-3) - [Step 4 (Optional): Configure Scheduled Refresh](https://help.precoro.com/getting-started-with-power-bi#step-4) ### What Is Power BI? Power BI is a Microsoft collection of business intelligence tools, services, apps, and connectors that allows you to create visually immersive and interactive reports from various data sources.  If you rely on Power BI to track your company’s key metrics across multiple systems and tools, you can use the Precoro Power BI custom connector for direct data transfer from Precoro to Power BI. ### How Data Is Transferred from Precoro to Power BI Power BI uses data connectors—small applications designed to access data from specific services or sources.  These connectors come in two types:  1. **Built-in Connectors** are pre-installed and certified by Microsoft. They are available directly via the Get Data module. 2. **Custom Connectors** have to be added by users to the Get Data module manually. They connect Power BI with data sources not covered by the built-in options. These connectors are only available to users who have the connector file on their PC. Precoro uses a custom connector that you can get from your Customer Success Manager. It allows you to: - Easily and safely connect Precoro and Power BI via API. - Build reports and dashboards using your company’s data. - Schedule automatic data updates. 💡 **Please note**: To use this solution, you need a Free/Pro/Premium Power BI Desktop license and admin rights on the machine where the connector will be installed. This add-on incurs an additional fee. ### Power BI Custom Connector & Precoro API limits To fetch data, the Power BI connector uses **Precoro’s API**. This ensures data security: you get **read-only** access to your data through our API. **Precoro API request limits for Power BI:** - **300 requests per minute** - **1,500 requests per hour** - **3,000 requests per day** Learn more about using API in Precoro and request limits [here](https://help.precoro.com/using-api-in-precoro?hsLang=en#API-Requests-Limits). To load the required data, please set up the integration with these limits in mind.  When you connect a table, Power BI sends **multiple requests**, not a single one. If you exceed the API limits, you’ll encounter the 429 Too Many Requests error. The number of requests depends on the filters you set and the number of records (documents) that match those filters. The next section features the best practices for staying within the limits and analyzing all relevant information. ### How to Ensure Successful Data Transfer Please follow the three principles explained below when setting up and using the integration. They’ll help you get all the necessary information from Precoro to Power BI without delays and stay within the API request limits. **1. Connect only the tables you truly need.**Before you start loading the data, take some time to plan which dashboards and reports you want to build—this will help you identify exactly which tables are necessary. Keep in mind that some data is duplicated across tables. For example, you may not need the **Suppliers** table because supplier details are already available in **Purchase Orders**. [![Tables](https://help.precoro.com/hs-fs/hubfs/Tables.png?width=670&height=266&name=Tables.png)](https://help.precoro.com/hubfs/Tables.png?hsLang=en) If you no longer need one of the previously connected tables or if you exceed the limits, you can delete connections on the Query Editor page.  **2. Use filters to narrow the data.**For the first connection, load data for a **minimal time period** using the **createDate** filter (for example, only for the last two days). This approach significantly reduces the number of API requests and helps ensure the initial data load completes successfully.  [![Filter-1](https://help.precoro.com/hs-fs/hubfs/Filter-1.png?width=670&height=503&name=Filter-1.png)](https://help.precoro.com/hubfs/Filter-1.png?hsLang=en) **3. Enable** [**Incremental Refresh**](https://help.precoro.com/configure-incremental-refresh-in-power-bi?hsLang=en) **in Power BI.**At this step, you can define the **time range** for each table (to specify how far back you want to load data) and set up **archiving rules**. This setup ensures that Power BI updates only recent data and doesn’t send unnecessary requests for data that has already been imported. As a result, you’ll minimize future API requests and keep your data refreshes efficient. Please note that if you archive data for an extended period, the limits may be exceeded during data loading due to the large number of records. In this case, you’ll need to shorten the period. ### How to Connect Power BI and Precoro Here are the steps you need to complete to establish the integration correctly. A guide provided for each step will walk you through the process in more detail. Please keep in mind the recommendations for [successful data transfer](https://help.precoro.com/getting-started-with-power-bi#data-transfer) to load the necessary information quickly and stay within the request limits. #### Step 1: Install the Connector Precoro’s custom connector allows Power BI to access the data stored in Precoro. Learn how to install it in [this article](https://help.precoro.com/how-to-set-up-the-power-bi-custom-connector-1?hsLang=en). #### Step 2: Select the Necessary Data Tables and Filters Once you have installed the connector, assess and plan which metrics you need to track with Power BI. Select the tables according to your needs, filter only the required data to speed up data transfer, and load data for the minimal time period to comply with the request limits. Learn more about connecting the tables in [this guide](https://help.precoro.com/how-to-load-and-transform-data-tables-via-the-power-bi-custom-connector?hsLang=en). #### Step 3: Configure Incremental Refresh Setting up Incremental Refresh is required to ensure there are no duplicate or unnecessary requests that hinder data transfer. It helps you enhance performance by only loading the changed data and keeping the information used in your analytics up-to-date. Learn how to configure it [here](https://help.precoro.com/configure-incremental-refresh-in-power-bi?hsLang=en). #### Step 4 (Optional): Configure Scheduled Refresh To update your data automatically, you can set up a scheduled refresh with the frequency and parameters that suit your needs. Find the detailed guide [here](https://help.precoro.com/how-to-set-up-a-scheduled-refresh-for-power-bi-1?hsLang=en). - [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