How do you connect PrestaShop to Power BI?

Learn how to connect PrestaShop to Power BI with the Webservice API, shape data in Power Query, and configure scheduled refresh.

Connect PrestaShop to Power BI through PrestaShop’s Webservice API and Power Query’s Web connector. For scheduled reports, give Power BI read-only API access and check that refresh works after publishing.

How do you connect PrestaShop to Power BI?

  1. Enable the PrestaShop Webservice API. In your store’s back office, go to Advanced Parameters → Webservice and enable it. Create an access key with GET-only permissions for the resources you need, such as orders, order details, and products. PrestaShop’s API provides access to store resources through URLs under /api/. (devdocs.prestashop-project.org)

  2. Test an endpoint. For example, try https://yourstore.example/api/orders?display=full&output_format=JSON with an API client. Replace the domain with your shop’s address. display=full requests all fields, while output_format=JSON asks for JSON output. Large collections may need pagination using PrestaShop’s limit parameter. (devdocs.prestashop-project.org)

  3. Load the data in Power BI Desktop. Choose Get Data → Web, enter the API endpoint, and authenticate using Basic authentication with the API key as the username and a blank password. PrestaShop recommends sending the key through an Authorization header rather than putting it in the URL, where it could be exposed in browser history or server logs. If Power Query’s credential prompt does not handle your setup, use a controlled API-to-database or staging layer rather than embedding the key in a report. (devdocs.prestashop-project.org)

  4. Shape the data in Power Query. Expand the JSON records into columns, remove fields you do not need, and check date, number, and text types. Load separate resources as separate tables, then relate them using their IDs. For sales analysis, order headers and order details are different records, so decide whether each report should summarize orders or individual order lines.

  5. Publish and check refresh. After publishing, set the data-source credentials in the Power BI service and test a refresh. Power Query’s Web connector supports web requests, but authentication and refresh behavior can depend on how the query is built. Microsoft notes that its Web API authentication option is not supported in the Power BI service, so verify the published model rather than assuming a Desktop connection will refresh online. (learn.microsoft.com)

Option Best fit Trade-off
PrestaShop API with Power Query A small or moderate report using selected store resources. You must handle API authentication, pagination, and data shaping.
Database or staging layer Larger reporting workloads, more sources, or a model that needs prepared historical data. Requires database or integration setup; an on-premises source may need a gateway for scheduled refresh. (learn.microsoft.com)

Use the API route if you can configure and maintain its credentials and query. A database or staging layer may be a better fit when API pagination or refresh management becomes difficult, but it adds infrastructure and access-control work. For an on-premises source, Power BI’s scheduled-refresh setup may require a gateway and a matching gateway data-source configuration. (learn.microsoft.com)

Related Reading

Connect Zigpoll to your stack.Sync survey responses to the tools you already use — no code required.
See integrations

Latest in Ecommerce Analytics & Data

Start collecting feedback in 5 minutes.

Try our no-code surveys that visitors actually answer.

Questions or Feedback?

We are always ready to hear from you.