Power BI Export

by LENZ eBusiness GmbH

The extension "Power BI Export" allows you to upload your order data from your Shopware shop to an FTP server so that this data can be used by Power BI.

Expected release: March 2026

Compatible with:

Self-hosted

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

Features

Export your customer data, orders and order items

About the Extension

With this extension you can upload the order data from your Shopware shop to an FTP server so that this data can be used by Power BI. This allows you to create individual and detailed reports and gain deep insights into your business performance. With this information, you can make informed business decisions, optimise your sales strategies and promote the growth of your online shop.

The export file contains customer data, orders and the respective order items.

Notice: The export file is created using scheduled tasks. If the shop data is extensive, it may take longer to create the export files, as the scheduled tasks have to be run several times.

Options

Credentials

Username: Enter your username here
Password: Enter your password here

Technical information

Access is via the Shop API /lenz-power-bi-export/. Further information can be found in our documentation at docs.lenz-ebusiness.de
The exports can be loaded via a URL and imported into Power BI. The URL can be called up via the following request via Shell:
curl --request GET \
--url /lenz-power-bi-export/orders.json \
--header 'php-auth-pw: XXXXX' \
--header 'php-auth-user: XXXXXX'