Power BI with NopCommerce

Power BI with NopCommerce


  • 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


  • 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


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


  • 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


  • 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


  • 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


  • 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


  • 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

Leave your comment