Power BI Connector for CS-Cart

Features

• Connect CS-Cart and Multi-Vendor stores with Microsoft Power BI.
• Secure Azure Active Directory (Azure AD) OAuth 2.0 authentication.
• Automatic Power BI dataset and table creation.
• Storefront schema registration for structured reporting.
• Manual, scheduled, and real-time data synchronization.
• Incremental synchronization for improved performance.
• Synchronize Orders and Order Items data.
• Synchronize Customers, Products, and Categories.
• Synchronize Payments, Shipping Methods, Taxes, and Promotions.
• Synchronize Vendor data for Multi-Vendor stores.
• Synchronize RMA Return Request data.
• Embedded Power BI reports accessible from the CS-Cart admin panel.
• Workspace, dataset, report, and synchronization management.
• Detailed sync logs and audit trail monitoring.

Power BI Management Panel

A dedicated Power BI section is available under the Marketing menu, providing centralized control over all Power BI operations.

• Connect and authenticate with Microsoft Power BI.
• View and manage available Power BI workspaces.
• Access and manage synchronized datasets.
• Run manual synchronization directly from the admin panel.
• Monitor synchronization status and execution details.
• Access linked Power BI reports and dashboards.

Dataset Management in Power BI

The connector automatically creates and manages Power BI datasets from your CS-Cart store data, making it easy to build reports and dashboards without manual data preparation.

• Automatically create datasets in the selected Power BI workspace.
• Register storefront data schemas directly from CS-Cart.
• Generate Power BI tables for orders, products, customers, categories, vendors, and returns.
• Keep datasets updated through manual, scheduled, or real-time synchronization.
• Access and manage all synchronized datasets from the Power BI section in the admin panel.
• Use datasets as the foundation for creating custom Power BI reports and dashboards.

Data Synchronization Settings

Manage how storefront data is synchronized between CS-Cart and Microsoft Power BI.

• Configure incremental synchronization mode for efficient data transfers.
• Set synchronization frequency based on business requirements.
• Define batch size for optimized processing of large datasets.
• Enable real-time synchronization for orders.
• Enable real-time synchronization for product updates.
• Secure scheduled synchronization using a cron security key.
• Support manual, scheduled, and event-driven synchronization.

Reports, Logs & Audit Tracking

Monitor synchronization activities and access Power BI reports directly from the CS-Cart administration panel.

• Access Power BI reports associated with connected workspaces.
• Visualize sales, customer, product, and vendor analytics.
• Track synchronization history through detailed logs.
• Review successful and failed synchronization attempts.
• Monitor user actions and configuration changes using audit logs.
• Simplify troubleshooting and compliance monitoring.