Power BI with NopCommerce

You can use the Power BI Plugin to access your Power BI reports. It is not necessary to be familiar with Power BI Desktop, but you must have the program installed on your PC and be logged in with a Microsoft account.

Integrating the Power BI Plugin in your store, the store owner can connect their database to their Microsoft Power BI account

REPORT SPECIFICATIONS

  • Sales Summary
  • Sales by City
  • Quantity and Sales by Day
  • Sales by Category and Product
  • Sales by Product
  • Sales by Vendor
  • Sales by Month
  • Quantity and Sales by Week of Year
  • Sales, Sales LY and Max of Product ID by Product Name
  • Easy customizable

PLUGIN SPECIFICATIONS

  • Easily configurable
  • Separate Report Database (Selectable)
  • Previous Data Import to Report Database
  • Auto Sync Data with Report Database
  • Power BI Report Dataset Publish
  • Dynamic Power BI Connection Details Update

PRE-REQUISITES

  • The plugin requires you to install the Nop-Staion Core plugin first.
  • Power BI Account and Gateway needed

INSTALLATION

  • Download the NopStation Power BI Plugin from our store https://nop-station.com/customer/downloadableproducts
  • Upload the NopStation.PowerBI zip file using the "Upload plugin or theme" button
  • Go to Administration, reload the 'list of plugins'. Install 'Nop-Station Core' Plugin first and then install 'Nop-Staion Power BI'
  • To make the plugins functional, restart the application
  • Enable the plugin with 'Edit' option and Configure it

POWER BI ACCOUNT & GATEWAY CONFIGURATION

  • Register or Login to Power BI account
  • Download and inastall Power BI Gateway (recommended)
  • Run the Gateway
  • Login into it using Power Bi account credential
  • Register a new gateway

POWER BI APPLICATION REGISTRATION

  • Go to Power Bi apps
  • Register an application for Power BI. Application type will be Native (for apps that run on client devices, such as Android, iOS, Windows, etc.)
  • Check Select all in API access section
  • Click Register button. Copy the Application ID and save it into plugin configuration page

PLUGIN CONFIGURATION

  • Select a database for Data Warehouse. Check Use same db for report to use your eCommerce store database as Power BI data warehouse. If you want a separate database for that, keep it unchecked and click Edit database configuration
  • Enter database connection values and click Save button. It will create database (if not exists) automatically. Make sure your desired report database server is accessible from your application and Power Bi gateway**
  • If database is created successfully, it will show Database status as Connected and Send data to report db button will appear**
  • Cick Send data to report db button**
  • Cick Start button**
  • If report database (either same database or a separate one) Integrated Security is set to True (Windows authentication), then insert the machine username and password
  • ** for separate report database only

POWER BI DATASET PUBLICATION

  • Go to plugin configuration page
  • Click Publish .pbix button
  • Enter Import name (dataset name) and click Start button
  • After a while, User code field and Verify user button will appeared. Copy User code and click Verify user button. It will open a popup window, where you authorize the user
  • Paste the User code in popup window. Click Next and complete Power Bi login process
  • After completing authorization process, popup window will be closed and a list of registered Gateway list will be appeared. Select a gateway and click Save button
  • Go to Power Bi Datasets Click on (...) and then Settings
  • Expand Gateway connection tab
  • Click on right arrow button of your selected gateway
  • Select a datasource (Nop Datasource) from Maps to dropdown list
  • Click Apply button
  • To set scheduler for auto data refresh, expand Scheduled refresh tab and set time and zone