The image is a graphic with logos representing an integration between Power BI, depicted with its distinctive yellow bar chart logo, and Magento, represented by its characteristic orange hexagon logo with the text "Open Source eCommerce" beneath it.

Imagine transforming your raw Magento data into visually compelling reports and dashboards. With the Power BI Integration Extension, you can gain a deeper understanding of your customers, products, and sales performance. This article provides a high-level overview of the configuration process, guiding you through the essential steps to unlock the potential of this extension.

Setting Up the Power BI Integration:

Purchase and Assign License:

  • Go to https://insightsready.com and log in to your account.
  • Purchase the required license and assign it to your Magento website.
  • Once assigned, a License Key will be generated.

Download/Copy License Key:

  • Navigate to "My Websites" menu on the Account page of insightsready.com.
  • Click on the "Details" link corresponding to your Magento website.
  • On the Website Details page, find the Online License Key and download it. Alternatively, if you prefer offline communication between Magento and insightsready.com, you can download the Offline License Key.

Website Details
Picture: Website Details

Obtain Extension Code:

  • If there are any documentation files or additional files to download, find them on the "Downloads" page.
  • Access the extension code using the composer repository. The access data for the repository will also be available on the Website's Details page.

Configure License Key:

  • Log in to your Magento admin panel.
  • Navigate to Stores Configuration (System Configuration for Magento 1).
  • Find the section named "Insights Ready General".
  • Enter the License Key obtained in step 2 into the corresponding field.
  • Save the configuration.

Client website details page on Insights Ready Website
Picture: Client website details page on Insights Ready Website

Connect Power BI:

  • Open Power BI.
  • Go to the "Get Data" menu.
  • Select "More..." to explore additional data sources.
  • Choose "Magento" from the list of available connectors.
  • Enter the necessary credentials and connection details to establish the connection between Power BI and your Magento store.

License key configuration for Insights Ready
Picture: License key configuration for Insights Ready

By following these steps and consulting the provided resources, you'll be well on your way to harnessing the power of the Power BI Integration Extension and transforming your Magento data into actionable insights!