Prestashop Power BI connector

Take complete control over your cloud architecture without ever having to leave your PrestaShop admin panel.

• What it is: A full internal UI managing the three core Power BI objects.
• How it works: The Workspaces panel lets you import existing Power BI containers or create a brand-new workspace directly. Inside the Datasets and Tables panels, the module lists active structures, executes a Schema Diff to check if your PrestaShop attributes match your cloud tables, and gives you the option to Clear Rows (wiping old rows for a clean re-sync without destroying table designs).
• Why it matters: It saves massive administration time. You can organize separate analytical environments for multi-shop operations straight from a single control screen.

You can import, manage, and interact with your visual data analytics directly from your merchant back-office.

• What it is: A centralized in-plugin reporting center that serves as a bridge to bring your final cloud-hosted reports back into the PrestaShop workflow.
• How it works: With dedicated retrieval actions, merchants can click to directly fetch published elements from their active Power BI workspace onto this page. Clicking Embed brings up a secure, interactive lightbox modal inside the administration area. This modal loads your real-time data charts—such as order counts by status or sales trends—complete with structural side filters. From this view, administrators can also click Open in Power BI to jump straight to the source visualization on powerbi.com.
• Why it matters: It keeps your staff aligned without forcing them to constantly swap browser tabs or share external software profiles. Your team can securely review advanced business performance graphs right alongside their regular processing queues. It also features a Copy Embed Link option to securely generate tokenized storefront paths if you ever want to display specific operational metrics to front-end visitors.

When managing multi-employee fulfillment teams or external marketing contractors, ensuring data privacy and workflow integrity is vital.

• What it is: A local authorization matrix designed to restrict or grant module privileges based on default PrestaShop core worker roles.
• How it works: The module auto-detects and loads all operational store groups (such as Logisticians, Salesmen, or Translators) on the left sidebar. Selecting a profile loads a comprehensive permission checklist containing nine critical system functions, including View Dashboard, Manage Settings, Manage Workspaces, Manage Sync, and Manage Access Control. Managers simply check the desired boxes and click Save Matrix to commit changes.
• Why it matters: It provides complete database security and operational safety. For instance, you can easily allow warehouse packers (Logistician) to check shipping trends on the dashboard or view operational trails without giving them the ability to accidentally reset your Azure API configurations or wipe cloud queues. Note that for security backup protection, the system enforces a guardrail where the main account (SuperAdmin) always maintains full, un-editable access across all fields.

Setting up your secure authentication bridge takes place within the Authentication tab, mirroring the parameters generated in your Admin Center.

• What it is: The security handshake configuration panel.
• How it works: You paste your unique Tenant ID, Client ID, and Client Secret directly into the encrypted inputs. The module provides two distinct Grant Types: Client Credentials or Password (Resource Owner). For automated, hands-off background refreshes, choosing the Resource Owner flow allows the module to refresh its own tokens without requiring periodic manual logins.

• Azure OAuth 2.0 authentication with Client Credentials or Password grant
• 14 PrestaShop entities available for export: Orders, Order Items, Customers, Products, Product Combinations, Categories, Carts, Cart Rules, Taxes, Carriers, Order Slips, Payments, Inventory, and Shops
• Push Datasets creation in Power BI with automatic schema generation
• 7-step Setup Wizard for guided initial configuration
• Flexible sync modes: Manual, Scheduled (cron), and Live (hook-driven)
• Saved sync profiles for customized data sync workflows
• Visual Query Builder for custom data exports
• Import and embed Power BI reports and dashboards
• Configurable alert system for monitoring business metrics
• Unified logging system with CSV export
• Per-employee access control with granular permissions
• REST API endpoints for programmatic access