{"id":12467,"date":"2026-09-10T23:34:14","date_gmt":"2026-09-10T23:34:14","guid":{"rendered":"https:\/\/zappysys.com\/blog\/?p=12467"},"modified":"2026-09-10T23:34:14","modified_gmt":"2026-09-10T23:34:14","slug":"how-to-get-data-from-shipstation-into-power-bi","status":"publish","type":"post","link":"https:\/\/zappysys.com\/blog\/how-to-get-data-from-shipstation-into-power-bi\/","title":{"rendered":"How to get data from ShipStation into Power BI"},"content":{"rendered":"

Introduction<\/h2>\n

\"\"<\/a><\/p>\n

ShipStation is a leading shipping and order management platform used by eCommerce businesses to manage orders, shipments, and fulfillment across multiple sales channels. Many organizations need ShipStation data in Power BI to monitor fulfillment performance, shipping costs, and order trends.<\/p>\n

Using the ZappySys ODBC Driver for REST APIs, you can query ShipStation API data with SQL and load it into Power BI without writing custom connector code. This tutorial shows how to create a ShipStation ODBC DSN, configure API authentication, preview data, connect Power BI, and run practical SQL queries.<\/p>\n

Prerequisites<\/span><\/h2>\r\nBefore we perform the steps listed in this article, make sure the prerequisites are met:\r\n
    \r\n \t
  1. Basic knowledge of SSIS package\u00a0development using\u00a0Microsoft SQL Server Integration Services<\/em>.<\/li>\r\n \t
  2. Make sure the SSIS designer<\/a> is installed.<\/li>\r\n \t
  3. Download and install ZappySys SSIS PowerPack<\/a>.<\/li>\r\n<\/ol>\r\nNOTE:<\/strong> If you are planning to deploy packages to a server and schedule their execution later, read this article<\/a>.<\/div>\n

    Steps<\/h2>\n

    Get ShipStation API credentials<\/h3>\n
      \n
    1. Sign in to your ShipStation account.<\/li>\n
    2. Go to Account Settings \u2192 API Settings<\/strong>.\n
    3. Generate your API Key<\/strong> and API Secret<\/strong> \u2014 store both values securely.\n
      \"\"<\/a>

      ShipStation – Generate token<\/p><\/div><\/li>\n<\/ol>\n

      Create a new ODBC DSN using ZappySys JSON Driver<\/h3>\n
        \n
      1. Search for ODBC<\/strong> in the Windows Start menu and open ODBC Data Source Administrator<\/strong>.
        \n        \"\"<\/a><\/li>\n
      2. In User DSN<\/strong> or System DSN<\/strong>, click Add<\/strong>.<\/li>\n
      3. Select ZappySys JSON Driver<\/strong>, then click Continue<\/strong>.
        \n        \"\"<\/a><\/li>\n<\/ol>\n

        Configure ShipStation API connection<\/h3>\n
          \n
        1. Enter a ShipStation endpoint URL in this format:
          \nhttps:\/\/ssapi.shipstation.com\/orders<\/span><\/span><\/li>\n
        2. In Connection Type<\/strong>, select HTTP<\/strong> and click Configure<\/strong>.<\/li>\n
        3. Set Credential Type<\/strong> to Basic Auth (Username\/Password)<\/strong>.<\/li>\n
        4. Set Username<\/strong> to your ShipStation API Key.<\/li>\n
        5. Set Password<\/strong> to your ShipStation API Secret.<\/li>\n
        6. Click OK<\/strong> to save HTTP authentication settings.\n
        7. Set HTTP Request Method<\/strong> to GET<\/strong>.<\/li>\n
        8. Add the following HTTP Header<\/strong>:\n