Microsoft Power BI Integration

View Supplier Portal data automatically in Power BI

Never download a vendor report again. Crisp’s secure integration automatically updates your Power BI reports with a live data feed.

All your data, fully automated

No more need for manual CSV downloads and data consolidation

Live data feed of continuously updated information from Crisp’s comprehensive, secure online data warehouse

Automatically updates your Power BI reports and dashboard visualizations

Free Power BI application template for Crisp data available in the Microsoft Office 365 app store

Crisp Tools and Features

Get more from your data with these handy dashboard features:

Automatic reports

Crisp automatically ingests new supplier portal reports when they’re available, saving you valuable time

Templates

Leverage templates with UNFI sales and supply reports

Consolidate all your data sources

Crisp also aggregates data from retailer and distributor portals such as:

How to setup a Power BI outbound connector with Crisp

Crisp’s Power BI integration is simple and secure

  1. Add Connector

    Once you’ve purchased Crisp, add the Power BI connector inside the Crisp platform

  2. Generate OData feed

    The Crisp platform will provide you with the OData URL to set up the connection in Power BI

  3. Set up OData feed in Power BI

    Configure the connection and select the list of reports you want to work with

  4. Enjoy your data

    Crisp will export historical data and automate future reports

Case Studies

  • The Honey Pot

    By using Crisp’s platform and Promomash’s promotion planning features, The Honey Pot is able to accurately forecast demand and reveal sales opportunities.

  • Illy

    Illy uses Crisp’s real-time dashboards to review stock on a day-to-day basis and ensure that there’s always plenty of product to meet their targets.

  • PANOS

    Crisp’s real-time business dashboards give the PANOS team real-time answers in a matter of minutes.

  • Aura Bora

    With Crisp’s Unified Distributor dashboard, sparkling water brand Aura Bora was able to save tens of thousands of dollars by avoiding stock-outs.

  • SunButter

    With the help of Crisp’s void detection feature, SunButter can reduce out-of-stocks and continue to grow amidst supply chain challenges.

  • Mid-Day Squares

    With Crisp, Mid-Day Squares’ success is anything but bite-sized. Mid-Day Squares uses Crisp’s customized dashboards to maximize every retail opportunity.