Power BI / Azure integration

by scope01

Rating: no rating ( write a review )

Downloads: <10

With the Shopware Power BI Connector from scope01, you can seamlessly import data from Shopware into Power BI and further process it there in the Microsoft world.

Annually €11.19* /month €178.98 * €134.24* /year after first year €178.98* /year Promotion valid until 6 December 2024 23:59 37.82% discount This is the combination of a 20.72% promotional discount and a 17.09% annual discount.

Monthly €13.49* /month for 12 months, then €17.99* /month Cancelable monthly Promotion valid until 6 December 2024 23:59 25.01% discount

Compatible with:

6.5.0.0 - 6.6.9.0

Includes:

Free trial month

The subscription starts with a free trial month during which it can be canceled at any time.

All updates

During the subscription all released updates are included for free

Support from the Extension Partner

In case you have any questions or problems with your extension you can always ask the Extension Partner for help during the subscription.

Description

About the Extension

Discover the ultimate plugin for Shopware 6 that takes your business data to a whole new level: The Shopware Power BI Connector from scope01. Turn your product, customer and order data into valuable insights and strategic decisions by seamlessly bridging the gap between your Shopware online store and Microsoft Power BI.

With our easy-to-use interface, you can now effortlessly transfer data from Shopware 6 to Microsoft Power BI. Say goodbye to time-consuming manual data entry and updates. Our plugin automates the process and ensures that your data is always up-to-date, so you can focus on what really matters - driving your business forward. The data is made available both via API and via email as an attachment.

The benefits are obvious:

Real-time insights: Keep track of sales trends, inventory levels, and customer behavior in real time.
Intuitive visualizations: Create stunning dashboards and reports with Power BI's powerful visualization capabilities.
Data-driven decisions: Base your business strategy on sound, data-driven insights.
Save time and resources: Free yourself from manual data export and import to free up time for more important tasks.
Scalability: whether you run a small online store or a growing e-commerce platform, our plugin adapts to your needs.

Increase your data analysis efficiency and make informed decisions based on valid data.

Note: An Azure account with PowerBI Cloud is required to use scope01's Power BI / Azure integration.

Details

Available: English, German
Latest update: 3 December 2024
Publication date: 27 September 2023
Version: 2.0.1
Category: Middleware & Connectors

Resources

Reviews (0)

Write a review

If you downloaded this extension you can write a review in the Shopware Account.

Write a review

No reviews found.

About the Extension Partner

scope01

See all extensions

Partner Status

Shopware
Gold Partner
Shopware
Extension Partner

Details

Ø-Rating: 4.8

Average rating of 4.8 out of 5 stars
Partner since: 2017
Extensions: 13
Certifications: Certifications

Support

Based in: Germany
Speaks: German, English
Response time: Very quickly

Shopware 6 certified

Azure and PowerBi configuration

Azure App registration

An app must be registered in Azure for the plugin to communicate with PowerBi.

Go to “App registrations” in Azure and click “New registration”
1. Name: the name of the app for example the store name
2. Supported account types
3. Redirect URL: for example the store URL
Go to “Api permissions” in the created app and click “Add a permission“
1. Select “Power Bi Service”
2. Select “Delegated permissions”
3. The PowerBi plugin only needs “Dataset.ReadWrite.Al” and “Workspace.Read.All” permissions
4. Click “Add permission”
Now we need to create a “Client secret”. Go to “Certificates & secrets” and click “New client secret”
1. Note down the “Value”.

PowerBi configuration

In PowerBi service principals must be allowed to use the PowerBi API.

Go to the “Admin portal” under settings.
Under “Tenant settings” search for “Developer settings”
1. Enable “Allow service principals to use Power BI APIs”

You also need to give the “PowerBi Service (Service Principal)” access for the workspace.

Go to your workspace (not “My Workspace”)
Click “Manage access”
Add “PowerBi Service (Service Principal)”
Add your created App

Installation and configuration

The Plugin can be installed normally like every other Plugin.

Settings

Email Export

Active: activate / deactivate email export
E-Mails: The emails that should get the email separated with a comma

If enabled, the order data will be sent once a day to the configured emails in a csv file.

The first export will export the orders from the current day. After that, the orders from the last execution until now are exported.

PowerBi Configuration (for direct export to PowerBi)

Set Workspace-ID: can be found in Url (for example: https://app.powerbi.com/groups/05asdede0-7cc2-4ad7-8e39-acd73fab27dk )
Dataset Name: choose a dataset name (must not exist in PowerBi)
Dataset ID: leave empty
Order Table Name: choose name for order table in PowerBi dataset

Azure Configuration (for direct export to PowerBi)

Client ID : can be found on overview page of Azure App Registration
Client Secret: above created in Azure App Registration
Tenant ID / Directory ID: can be found on overview page of Azure App Registration

After configuration

After configuration is done run php bin/console powerbi:init. This command will create the dataset und table in PowerBi.

Email Template

After installation, a new email template appears under Settings->Email Templates with the name PowerBi Export Orders Mail

Here you can insert your own text. Important: there are no variables available.

Messenger

Make sure all Shopware cron jobs are running.

php bin/console scheduled-task:run

php bin/console messenger:consume async

Technical

Events

EmailExportLineItemEvent

Is called every time a line item is added to a the CSV file.

Example:

public function onLineItemAdd(EmailExportLineItemEvent $event): void { $event->addExtension(['custom_name' => $event->getLineItemEntity()->getCustomFields()['test']]); }

This will add a column to the CSV with the name “custom_name” und the value of the custom field “test“.

BeforeCsvCreatedEvent

Is called before CSV is created finally.

public function beforeCsvCreated(BeforeCsvCreatedEvent $event): void { $data = $event->getData(); foreach ($data as $lineItemId => $row) { $lineItem = $this->lineItemRepository->search(new Criteria([$lineItemId]), Context::createDefaulktContext())->first(); $data[$lineItemId]['custom_name'] = $lineItem->getCustomFields()['test']; } $event->setData($data); }

This will add a column to the CSV with the name “custom_name” und the value of the custom field “test“.

Exported fields

OrderNo
OrderPos
Date
ArticleNumber
ArticleDescription
Amount
Units
Price
User
Segment

Important Classes

Classname // Function

Migration1686394103AddMailTemplate: Create the default email template on installation

ExportOrdersTaskHandler: Export of order data to csv and sending the Email

PowerBiClient: Handles connection to PowerBi

SendOrderHandler: Sends order to PowerBi

Roadmap

SalesChannel Config for Email Export
- if desired, add new option to Config:
  - export in one file
  - one or separate file per SalesChannel
Customize the exported fields (Email Export and PowerBi API)
Create FlowBuilder Actions and Triggers for easier manipulation of data
UnitTesting
Integration of a PowerBi report into the Shopware backend https://learn.microsoft.com/en-gb/power-bi/collaborate-share/service-embed-secure )
Integration of targets (ScoreCards) from PowerBI
Export to Microsoft SharePoint