CORE-Microsoft Power BI integration

CORE allows you to integrate with Microsoft Power BI. Power BI is a business intelligence service by Microsoft wherein you can track your business analytics and create reports and dashboards on it. It is a powerful tool that connects your various data sources and turns them into meaningful, centralized, visual and interactive insights for your business. You can ingest available CORE data through the CORE APIs into the Power BI application to generate graphs and reports outside of CORE. Check out the Power BI Documentation by Microsoft for details.

To use Power BI with CORE, follow these instructions:

  1. Download Microsoft Power BI from the Download Center and then install it on your computer.
  2. Open the Power BI Desktop app.
  3. Browse to the File tab > Get data and click Get data to get started to launch the Get Data dialog,
  4. Select All or Other on the left and look for BQE CORE in the list. If you cannot find BQE CORE, check to make sure you are on the latest version of Power BI.


  5. Click Connect. You are prompted to connect to a third-party service; click Continue.
  6. On the BQE CORE > CORE Login dialog, click Sign in.


  7. You will be prompted to log into CORE.


  8. On the Log In screen, enter your CORE Email and Password. Click Login. The BQE CORE connector will remember your credentials in the future. 
  9. You are prompted to select your CORE company file. Click Grant Permission.


  10. Next, click Connect on the dialog.
  11. On the Navigator screen, select a CORE module in the Display Options list (say TimeEntry).


  12. The BQE CORE connector is powered by CORE Public APIs. You can apply the Where and Expand filters along with the operators to get insights about the relevant data only. Check the available filters and field mappings here: CORE API Documentation > API Reference.

Note: For the TimeEntry table, the connector only retrieves the entries of the last one month if you do not provide an explicit Date filter in the Where field. Please provide a date range in the Where field if you want to retrieve the entries of dates other than the last one month. For example, use date > '2022-01-01' if you want to retrieve entries from the beginning of the year 2022.

Was this article helpful?
1 out of 2 found this helpful