{"id":4825,"date":"2018-09-14T15:24:15","date_gmt":"2018-09-14T15:24:15","guid":{"rendered":"https:\/\/zappysys.com\/blog\/?p=4825"},"modified":"2026-03-11T07:08:28","modified_gmt":"2026-03-11T07:08:28","slug":"import-amazon-mws-data-power-bi","status":"publish","type":"post","link":"https:\/\/zappysys.com\/blog\/import-amazon-mws-data-power-bi\/","title":{"rendered":"How to Import Amazon MWS data in Power BI"},"content":{"rendered":"

Introduction<\/h2>\n
\n\u26a0\ufe0f<\/span> Deprecation Notice: MWS API is deprecated<\/strong>
\nAmazon’s MWS (Marketplace Web Service) is being deprecated and replaced by the newer AWS Selling Partner API (SP-API).<\/strong> For a more robust and secure integration, we recommend<\/strong> using our AWS Selling Partner (SP-API) Connector<\/a>.<\/strong> As Amazon is phasing out MWS functionality and eventually plans to fully deprecate it.
\n<\/div><\/div>\n

\"\"<\/a>In our previous blog we saw how to call REST API in Power BI<\/a> to import data from JSON based REST API services. Now let’s continue on that and learn how to import Amazon MWS data in Power BI using XML driver<\/strong>. To learn more about how to consume Amazon MWS data<\/strong> in ETL using SSIS check this article<\/a>.<\/p>\n

We will read data from Amazon MWS API using ZappySys XML Driver which is part of ODBC PowerPack<\/a>.<\/p>\n

<\/h2>\n

Requirements<\/h2>\n
    \n
  1. Active Amazon Seller Account needed (Make sure you have Professional Plan or higher<\/strong> (around $39\/month) to call Amazon MWS API)<\/li>\n
  2. You are already registered as a Developer<\/a> and you obtained AWS Access Key \/ Secret Key and Seller ID (i.e. Merchant ID) (see next section)<\/li>\n
  3. Download and Install ODBC PowerPack<\/a><\/li>\n
  4. You will also need Power BI Desktop (FREE)<\/a> installed<\/li>\n<\/ol>\n

    About Amazon MWS \/ API<\/h2>\n

    If you want to sell something on Amazon you can use their e-commerce platform with some monthly fee. You can setup your entire online store \/ inventory using admin interface.<\/p>\n

    Amazon Marketplace Web Service (Amazon MWS) is an integrated web service API that helps Amazon sellers to programmatically exchange data on listings, orders, payments, reports, and more. Using these API you can read or write data from your Seller account and integrate it inside your own Systems (e.g. Reporting \/ ETL \/ BI tools).<\/p>\n

    NOTE: Amazon MWS may allow only certain number of requests per minute depending which API you calling so you might want to use each call wisely. We will suggest you various techniques throughout this article so you can avoid errors so read each section carefully. You can find Throttling information on API help page itself (like this one<\/a>\u00a0see throttling section. Also this one<\/a>).<\/div><\/div>\n

    Obtain MWS API Access Key \/ Secret and Seller ID<\/h2>\n

    Very first thing to call any MWS API is to obtain Access Key, Secret Key and Seller ID (i.e. Merchant ID). To obtain this you first have to register a developer<\/a>.<\/p>\n

    Here is where to look for your Merchant ID and Key \/ Secret.\u00a0 Here is direct link to User Permissions<\/a> page.<\/p>\n

    \"How<\/a>

    How to get Amazon MWS developer keys and know your Merchant ID (i.e. Seller ID)<\/p><\/div>\n

    Getting Started<\/h2>\n

    Now let’s look at step by step instructions on how to call Amazon MWS API and then import into Power BI. In below steps we will use\u00a0\u00a0ZappySys ODBC PowerPack<\/a>\u00a0so make sure it’s installed first.<\/p>\n

    Using ScratchPad to Test\u00a0Amazon MWS API<\/h3>\n

    Each MWS API has set of required and optional parameters. You can refer each API page for details. For example\u00a0ListMatchingProducts<\/a> API which we will use as an example. To make MWS API testing \/ learning easy, Amazon provides\u00a0online testing tool called MWS ScratchPad<\/a>. We will use this tool to craft API requests and use that information in ODBC driver SQL queries and later import data in Power BI.<\/p>\n

      \n
    1. Open\u00a0MWS ScratchPad<\/a>\u00a0 by vising https:\/\/mws.amazonservices.com\/scratchpad\/index.html<\/strong><\/li>\n
    2. Select Products<\/strong>\u00a0API category and pick\u00a0ListMatchingProducts<\/strong> API<\/li>\n
    3. Enter your SellerID<\/strong> (i.e. Merchant ID), Developer AccessKey (i.e. AWSAccessKeyId<\/strong>) and Secret Key<\/strong> we obtained in the previous section. Enter MarketId (e.g. ATVPDKIKX0DER<\/strong> for USA Market) and other parameters as below and Click Submit to see response.\n
    4. Click on the Response Details<\/strong> Tab to extract some important information we will use for ODBC configuration. Notice attributes in red rectangles. They are the ones which we will need in the POST request Body. ZappySys Drivers supply many common parameters automatically but any API endpoint specific parameter must be supplied in the Request Body. For example you dont have to supply SignatureVersion, Timestamp, Signature or SignatureMethod<\/b>\n
      \"Calling<\/a>

      Calling Amazon MWS API in Scratchpad Testing Tool (Response Details Tab) – ListMatchingProducts Example<\/p><\/div><\/li>\n<\/ol>\n

      This API requires Market ID parameter so enter it as per your Market where you selling. For example USA marketplaceid =\u00a0ATVPDKIKX0DER. You can lookup correct MarketplaceId by checking this help (endpoints \/ marketplaces)<\/a>.<\/p>\n

      Create ODBC DSN Connection for MWS API \/ Test Query<\/h3>\n

      Once you have necessary details to call your Amazon MWS API, we can create ODBC DSN which will be used as a reusable connection for MWS API data access in apps like Power BI.<\/p>\n

      So let’s get started.<\/p>\n

        \n
      1. In your start menu search for ODBC<\/strong>\u00a0and select Data Source (64 bit)<\/strong>:\u00a0 If you need to access DSN by Service or scheduled Job then make sure you choose 64-bit DSN if caller App is 64 bit App.\n
      2. Use the User DSN page and press Add.\u00a0<\/strong>For DSN access by Service account or automated jobs which runs under different user, choose System DSN Tab, Make sure You create DSN for correct Bitness (i.e. for 64bit Apps create 64 Bit DSN)\n
      3. Select ZappySys XML Driver<\/strong>\u00a0and click Finish. Amazon MWS API is XML format so we selected XML driver however you can choose JSON or CSV Driver instead of XML if you dealing with JSON format.\n
      4. Once you see Driver Configuration UI window open, enter the following settings<\/li>\n
      5. ODBC DSN name (e.g. ZS – Amazon MWS API Connection)<\/li>\n
      6. Enter MWS API Service URL as below. Notice that we added \/Products\/2011-10-01 (This was extracted from previous section). You can check full list of Amazon MWS Endpoints here<\/a>. Because we are connecting to USA region we will use below URL.\n
        https:\/\/mws.amazonservices.com\/Products\/2011-10-01<\/pre>\n<\/li>\n
      7. Select OAuth<\/strong> from the Connection dropdown and Click Configure Settings<\/strong><\/li>\n
      8. On the Connection UI, Select OAuth Provider\u00a0Amazon Market Web Service (MWS)<\/strong><\/li>\n
      9. Enter your API Access Key<\/strong> and Secret Key<\/strong> (obtained from here<\/a>)<\/li>\n
      10. Your connection will look like below.\n
      11. Also configure Retry options to handle API limit reached error when you call API too often. For Amazon MWS we get Status code 503 when request is throttled so lets narrow down on which error we want to retry.\n
      12. Click OK to save OAuth Connection UI to go back to main UI<\/li>\n
      13. Now let’s use some information we gathered from the previous section (Using Scraptchpad Test).<\/li>\n
      14. Select POST<\/strong> for HTTP Request Method<\/li>\n
      15. Enter Body as below (Change last parameter with your own SellerID<\/strong> and if needed change your MarketPlaceId<\/a> too if its not USA)\n
        Action=ListMatchingProducts&MarketplaceId=ATVPDKIKX0DER&Query=harry%20potter%20dvd&SellerId=ZZZZZ-YOUR-SELLER-ID-ZZZZZ<\/pre>\n<\/li>\n
      16. Click on Select Filter to select correct node (in our case it will be Product node as below.\n
        $.ListMatchingProductsResponse.ListMatchingProductsResult.Products.Product[*]<\/pre>\n<\/li>\n
      17. Now Go to Throttling Tab and enter some delay (e.g. enter 20000 for 20sec delay after each request<\/strong>). This will slow down API calls so we don’t face errors about API Limit reached.<\/li>\n
      18. You can also consider enabling Data Caching<\/strong> for MWS API as below to avoid API throttling \/ rate exceeded error.\u00a0Change Cache Mode to Cache All<\/strong> (Use Cache for Metadata + Data Requests)
        \n
        NOTE: MWS may allow only certain number of requests per minute so you might want to use each call wisely. You can find Throttling information on API help page itself (like this one<\/a>\u00a0see throttling section. Also this one<\/a>).<\/div><\/div>\n
      19. Now goto Preview Tab and click on Green Play button to test query\n
      20. That’s it. We have successfully tested first query to read data from Amazon MWS API<\/li>\n<\/ol>\n
        Caching Metadata and Using in SQL Query<\/h3>\n
        We talked briefly about Data Caching but still there will be a time you will face such errors. So lets do another safeguard to reduce total API requests for MWS. Check this article<\/a> to learn about Caching and META Clause in SQL.<\/p>\n
        Here are high level steps to Use predefined Schema File so Driver doesn’t call API request to guess metadata.<\/p>\n
          \n
        1. Go to ODBC Preview window and write desired query you like to use. Click Preview Button<\/strong> to see sample data<\/li>\n
        2. Now click Save Metadata<\/strong> of query which we can use later. Save to File<\/strong> in our case (name as mws-query-meta.txt<\/strong> ).\n
        3. Now change our query as below\n
          SELECT \r\n ......\r\n ......\r\nFROM xxxxxxxxx\r\nWITH (META='c:\\somefolder\\mws-query-meta.txt')<\/pre>\n<\/li>\n
        4. That’s it. Use query like above when we import Amazon MWS data in Power BI in the next section.<\/li>\n<\/ol>\n
          Import Amazon MWS data in Power BI (List Orders Example)<\/h3>\n
          Now it’s time to load our data in Power BI and create reports.<\/p>\n
            \n
          1. Open Power BI Desktop and select the option Get data<\/strong>\n
          2. Get Data will allow adding the ZappySys ODBC driver. Go to Other<\/strong> and select ODBC.<\/strong>\n
          3. Now it’s time to import data. Basically, there are two modes to import data. Table Mode<\/strong> and Query Mode<\/strong>. Query mode is the most common way.\u00a0Select your DSN<\/strong> and click Advanced Option<\/strong> to enter custom SQL<\/strong> Query to Import your MWS API data. You can use ODBC DSN Data sources Preview tool to generate SQL Query. For example you can enter query to import Orders for specified date range. We have added some pagination attributes which we will cover in the next section. Click OK to continue.\n
            SELECT * FROM $\r\nWITH(\r\n\t ElementsToTreatAsArray='Order'\r\n\t,Src='https:\/\/mws.amazonservices.com\/Orders\/2013-09-01'\r\n\t,Filter='$.ListOrders[$tag$]Response.ListOrders[$tag$]Result.Orders.Order[*]'\r\n\t,RequestData='Action=ListOrders[$tag$]&SellerId=A1xxxxxxxxxxxxx&CreatedAfter=2018-09-01T04%3A00%3A00Z&MarketplaceId.Id.1=ATVPDKIKX0DER'\r\n\t,RequestMethod='POST'\r\n\t,NextUrlAttributeOrExpr='$.ListOrders[$tag$]Response.ListOrders[$tag$]Result.NextToken'\r\n\t,NextUrlSuffix='&NextToken=<%nextlink_encoded%>'\r\n\t,HasDifferentNextPageInfo='True'\r\n\t,EnablePageTokenForBody='True'\r\n\t,PagePlaceholders='body=|ByNextToken;filter=|ByNextToken'\r\n\t,WaitTimeMs=300 -- API throttling for pagination\r\n\t--Uncomment Caching Line to Speedup API calls and Avoid API Limit. Power BI issues many API calls behind the scene\r\n\t--,CachingMode='All',CacheStorage='File',CacheEntryTtl=120,CacheFileLocation='c:\\temp\\mws-orders.cache'\r\n\t--,DataConnectionType='OAuth'\r\n\t--,ScopeSeparator='{space}'\r\n\t--,ServiceProvider='AmazonMWS'\r\n\t--,ClientId='AKIAIWxxxxxxxxxxxxx' --Skip this to use DSN credentials\r\n\t--,ClientSecret='AKIAIWxxxxxxxxxxxxx' --Skip this to use DSN credentials\r\n\t--,UseCustomApp='True'\t\r\n)\r\n--Uncomment below if you are using Schema file for cached metadata\r\n--WITH (META='c:\\somefolder\\mws-query-meta.txt')<\/pre>\n
            <\/div>\n<\/li>\n
          4. Use above query for example and paste in Query editor while you Import Amazon MWS data.\n
          5. On the next screen select Windows Authentication
            \n<\/strong><\/p>\n
          6. Once data is imported you can use dataset to build your dashboard\n
            \"Load<\/a>
            Load Amazon MWS data in Power BI – Create Amazon Sales Dashboard<\/p><\/div><\/li>\n<\/ol>\n
            Using Pagination in Amazon MWS API calls<\/h2>\n
            Now let’s look at how to query certain API which allows paginated response. Pagination is fully explained here<\/a>. Certain APIs like ListOrders , ListOrderItems, ListInboundShipments, ListInventorySupply, GetFullfillmentOrder and few more supports Pagination.<\/p>\n
            When you call Paginated response next request changes Action with ByNextToken<\/strong> suffix. For example to get orders call ListOrders<\/a> and next request will be ListOrdersByNextToken<\/a><\/p>\n
            MWS API has multiple pagination patterns so based on which action you calling you have to use correct SQL parameters.<\/p>\n
            Amazon MWS API has strict throttling limits so make sure you call API accordingly. Calling same API too fast may result in throttling error. You can use WaitTimeMs<\/strong> option to wait after each API call so you do face throttling limit. Refer to MWS API help pages to see exact limit. <\/div><\/div>\n
            Using NextToken for Pagination (ListOrders Example)<\/h3>\n
            Many MWS API returns NextToken attribute in the response which you can pass in the body of next request until no more NextToken found in the response.<\/p>\n
            Check below example query for\u00a0ListOrders<\/a> API. We have enabled pagination by supplying few extra parameters in our original SQL Query.<\/p>\n
            SELECT * FROM $\r\nWITH(\r\n\t ElementsToTreatAsArray='Order'\r\n\t,Src='https:\/\/mws.amazonservices.com\/Orders\/2013-09-01'\r\n\t,Filter='$.ListOrders[$tag$]Response.ListOrders[$tag$]Result.Orders.Order[*]'\r\n\t,RequestData='Action=ListOrders[$tag$]&SellerId=A10JBWAX563WMC&CreatedAfter=2018-09-01T04%3A00%3A00Z&MarketplaceId.Id.1=ATVPDKIKX0DER'\r\n\t,RequestMethod='POST'\r\n\t,NextUrlAttributeOrExpr='$.ListOrders[$tag$]Response.ListOrders[$tag$]Result.NextToken'\r\n\t,NextUrlSuffix='&NextToken=<%nextlink_encoded%>'\r\n\t,WaitTimeMs=300 -- slow down to avoid throttling\r\n\t,HasDifferentNextPageInfo='True'\r\n\t,EnablePageTokenForBody='True'\r\n\t,PagePlaceholders='body=|ByNextToken;filter=|ByNextToken'\r\n\t--,DataConnectionType='OAuth'\r\n\t--,ScopeSeparator='{space}'\r\n\t--,ServiceProvider='AmazonMWS'\r\n\t--,ClientId='AKIxxxxxx'\r\n\t--,ClientSecret='AKIxxxxxx'\r\n\t--,UseCustomApp='True'\t\r\n)\r\n--Uncomment below if you are using Schema file for cached metadata \r\n--WITH (META='c:\\somefolder\\mws-query-meta.txt')<\/pre>\n
             <\/p>\n
            Using NextToken with operations that return HasNext \/\u00a0MoreResultsAvailable<\/h3>\n
            Some API has attribute which tells you to stop pagination (e.g. HasNext). Check below example query for\u00a0GetReportRequestList<\/a>. We have enabled pagination by supplying few extra parameters in SQL Query.<\/p>\n
            SELECT * FROM $\r\nWITH(\r\n\t ElementsToTreatAsArray='Product,ReportRequestInfo'\r\n\t,Src='https:\/\/mws.amazonservices.com'\r\n\t--,DataConnectionType='OAuth'\r\n\t--,ScopeSeparator='{space}'\r\n\t--,ServiceProvider='AmazonMWS'\r\n\t--,ClientId='Axxxxxxxxxxxxxx' --This will come from connection if you comment\r\n\t--,ClientSecret='Bxxxxxxxxxxxxxxxxx' --This will come from connection you comment\r\n\t--,UseCustomApp='True'\r\n\t,Filter='$.GetReportRequestList[$tag$]Response.GetReportRequestList[$tag$]Result.ReportRequestInfo[*]'\r\n\t,RequestData='Action=GetReportRequestList[$tag$]&Merchant=A10xxxxxxxxxxxxxxxx'\r\n\t,RequestMethod='POST'\r\n\t,NextUrlAttributeOrExpr='$.GetReportRequestList[$tag$]Response.GetReportRequestList[$tag$]Result.NextToken'\r\n\t,NextUrlEndIndicator='false'\r\n\t,StopIndicatorAttributeOrExpr='$.GetReportRequestList[$tag$]Response.GetReportRequestList[$tag$]Result.HasNext'\r\n\t,NextUrlSuffix='&NextToken=<%nextlink_encoded%>'\r\n\t,HasDifferentNextPageInfo='True'\r\n\t,EnablePageTokenForBody='True'\r\n\t,PagePlaceholders='body=|ByNextToken;filter=|ByNextToken'\r\n)\r\n--Uncomment below if you are using Schema file for cached metadata \r\n--WITH (META='c:\\somefolder\\mws-query-meta.txt')<\/pre>\n
            Some API calls return slightly different response so rather than HasNext attribute you will see\u00a0MoreResultsAvailable. In that case change\u00a0StopIndicatorAttributeOrExpr property to use\u00a0MoreResultsAvailable property.<\/p>\n
            Properties you need to change for pagination<\/h3>\n
            Now let’s look at properties which need to be changed to support pagination.<\/p>\n
            \n\n\n\n\n\n\n\n\n\n\n\n\n
            Property<\/td>\nDescription<\/td>\n<\/tr>\n
            Src<\/td>\nChange this to correct URL. Look at Scratchpad Response Details Tab and Findout first line after POST and before “?” . e.g.\u00a0\/Orders\/2013-09-01\u00a0 this will be used in your URL.
            \nExample:\u00a0<\/strong>
            \nhttps:\/\/mws.amazonservices.com\/Orders\/2013-09-01<\/td>\n<\/tr>\n
            Body (i.e. RequestData)<\/td>\nScratchpad shows HTTP POST section. You can copy that and remove\u00a0 System supplied parameters and then arrange all in one line to form your Body for request.<\/p>\n
            Example:<\/strong><\/p>\n
            POST \/Orders\/2013-09-01?AWSAccessKeyId=AKxxxxxxxxxx\r\n  &Action=ListOrders\r\n  &SellerId=A10zzzzzzz\r\n  &SignatureVersion=2\r\n  &Timestamp=2018-09-17T21%3A35%3A57Z\r\n  &Version=2013-09-01\r\n  &Signature=3GigipfRsQgzzzzzzzzzzzzzs%3D\r\n  &SignatureMethod=HmacSHA256<\/pre>\n
            Above HTTP POST can be used as below for your Body in ZappySys Driver. Rest of the parameters are automatically supplied by system. See special placeholder named [$tag$] this gets replaced at runtime when you set\u00a0EnablePageTokenForBody=True<\/strong> and HasDifferentNextPageInfo=True<\/strong><\/p>\n
            Action=ListOrders[$tag$]&SellerId=A10zzzzzzz&CreatedAfter=2018-09-01T04%3A00%3A00Z<\/pre>\n<\/td>\n<\/tr>\n
            Filter<\/td>\nChange this parameter according to XML structure in the response.
            \nFor example: If you see below response (first xml) in Scratchpad then your Filter will be
            \n$.ListOrdersResponse.ListOrdersResult.Orders.Order[*]<\/strong>
            \nto enable pagination refer to Sample listed here<\/a> (click Example response at the bottom of that page). In second response and onwards your Filter should be below (See Bold Part).
            \n$ListOrdersByNextToken<\/strong>Response.ListOrdersByNextToken<\/strong>Result.Orders.Order[*]However in Driver we replace ByNextToken<\/strong> with [$tag$]<\/strong>. Like below. Using [$tag$] will automatically pick up the correct filter based on page number. You must set HasDifferentNextPageInfo=True to use [$tag$] feature.$.ListOrders[$tag$]Response.ListOrders[$tag$]Result.Orders.Order[*]<\/strong>Example of first page response<\/strong><\/p>\n
            <?xml version=\"1.0\"?>\r\n<ListOrdersResponse xmlns=\"https:\/\/mws.amazonservices.com\/\r\n    Orders\/2013-09-01\">\r\n    <ListOrdersResult>\r\n        <NextToken>2YgYW55IxxxxxxxxxxxxVyZS4=<\/NextToken>\r\n        <LastUpdatedBefore>2017-02-25T18%3A10%3A21.687Z<\/LastUpdatedBefore>\r\n        <Orders>\r\n            <Order> ....... <\/Order>\r\n            <Order> ....... <\/Order>\r\n            <Order> ....... <\/Order>\r\n        <\/Orders>\r\n    <\/ListOrdersResult>\r\n<\/ListOrdersResponse><\/pre>\n
            Example of next page response<\/strong><\/p>\n
            <?xml version=\"1.0\"?>\r\n<ListOrdersByNextTokenResponse xmlns=\"https:\/\/mws.amazonservices.com\/\r\n    Orders\/2013-09-01\">\r\n    <ListOrdersByNextTokenResult>\r\n        <NextToken>2YgYW55IxxxxxxxxxxxxVyZS4=<\/NextToken>\r\n        <LastUpdatedBefore>2017-02-25T18%3A10%3A21.687Z<\/LastUpdatedBefore>\r\n        <Orders>\r\n            <Order> ....... <\/Order>\r\n            <Order> ....... <\/Order>\r\n            <Order> ....... <\/Order>\r\n        <\/Orders>\r\n    <\/ListOrdersResult>\r\n<\/ListOrdersResponse><\/pre>\n<\/td>\n<\/tr>\n
            NextUrlAttributeOrExpr<\/td>\nThis property defines which attributes indicate Token for next page. You can use this token in Body of next request (see\u00a0NextUrlSuffix and\u00a0EnablePageTokenForBody). You must set\u00a0EnablePageTokenForBody=true to use Extracted token in Body.<\/td>\n<\/tr>\n
            StopIndicatorAttributeOrExpr<\/td>\nSome APIs like\u00a0 GetReportRequestList<\/a>\u00a0stop pagination based on HasNext attribute value. Use this property to extract HasNext from response by supplying correct Filter expression. You also need to set\u00a0NextUrlEndIndicator property which defines static value which indicates the last page.<\/td>\n<\/tr>\n
            NextUrlSuffix<\/td>\nThis is used to create a string for NextToken attribute for next page request. If you want to just append extracted token to Body then you dont have to set this but in our case, we have to use &NextToken=EncodedValueOfExtractedToken so we have used\u00a0&NextToken=<%nextlink_encoded%><\/strong> expression.<\/td>\n<\/tr>\n
            PagePlaceholders<\/td>\nThis property contains [$tag$] values for first page and next pages. You can define tags for filter, body or header. Each pair must be pipe delimited. First value or pair is [$tag$]\u00a0 for first request and second value of the pair is [$tag$] for any next request afterwards. Our first request use blank value for [$tag$].
            \nExample:\u00a0\u00a0PagePlaceholders=’body=|ByNextToken;filter=|ByNextToken’<\/strong><\/td>\n<\/tr>\n
            HasDifferentNextPageInfo<\/td>\nSet to True – This enables use of [$tag$] inside body, filter, headers to use different values of first request and second onwards requests.<\/td>\n<\/tr>\n
            EnablePageTokenForBody<\/td>\nSet to True – This enables use of [$tag$] inside body to use different RequestBody values of first request and second onwards requests.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n
            Here is the preview of MWS API query output with Pagination Attributes.<\/p>\n
            \"Amazon<\/a>
            Amazon MWS API Pagination Example – Preview SQL Query Result<\/p><\/div>\n
            <\/h2>\n
            Import data from MWS Custom Reports (Inventory Report Example)<\/h2>\n
            Now lets look at how to extract data from Custom Report API<\/a>\u00a0(You must need ODBC PowerPack v1.1.1<\/strong> or higher). However reading data from Reports not single step process because report generation is Job style API. Which means you send report request and wait\u00a0 until its done. Once Report ready you have to read in CSV format or XML. Some Reports only available in CSV format.\u00a0Check this post<\/a> to understand how complex it can be to get data. We will make it simple for you to understand this in 3 steps. Basically calling reports requires minimum 3 API calls (see below)<\/p>\n
              \n
            1. Create a new report request – Cal\u00a0RequestReport<\/a>\u00a0API . It returns ReportRequestId<\/strong> (You can use it in the next step)<\/li>\n
            2. Check Report Status see its done – Call GetReportRequestList<\/a>\u00a0API (Pass ReportRequestId<\/strong> got in the previous step to get data for only one Report request we care). Keep checking Report Status every few seconds until you get _DONE_<\/strong> status in response.<\/li>\n
            3. Read Report Data – Call GetReport<\/a>. This API call returns CSV or XML data. So use correct Driver for this step. If CSV data is returned then we must use CSV Driver rather than XML Driver.<\/li>\n<\/ol>\n
              Now lets see how to get this 3 steps done in Power BI. In this example, We will get Inventory by calling\u00a0_GET_MERCHANT_LISTINGS_DATA_<\/strong> report type.<\/p>\n
                \n
              1. Create a directory c:\\temp<\/li>\n
              2. Create new ZappySys XML Driver DSN<\/strong>\u00a0(User DSN) using same steps we described before. Lets name this DSN as ZAPPY-MWS-API-XML<\/strong><\/li>\n
              3. Create new ZappySys CSV Driver DSN<\/strong> \u00a0(User DSN) using same steps we described before (Except the Driver Type should be ZappySys CSV Driver<\/a>). Lets name this DSN as\u00a0ZAPPY-MWS-API-CSV<\/strong><\/li>\n
              4. Once you done with ODBC DSN Setup open or create new Power BI Project.<\/li>\n
              5. Click on Create Source > from Blank Query\n
              6. When Query Editor Shows up click on Advanced Editor and paste below code (Its Power BI M Language<\/a>). If you are unsure how to write Power BI check this tutorial<\/a>.
                \nReplace MarketPlaceId and Seller ID in the script (i.e.\u00a0A1xxxxxx and\u00a0A2xxxxxx ). See we are using\u00a0ReportType=_GET_MERCHANT_LISTINGS_DATA_<\/strong>\u00a0 but you can use any valid report ID                 from here<\/a>. You can also pass other optional parameter available for each report Type (e.g. StartDate and EndDate)<\/p>\n
                \"Edit<\/a>
                Edit Power BI Query Script – Use custom M Language Script to import data from ODBC or other Relational<\/p><\/div>\n
                Power BI M Script (New Driver) – Import MWS Custom Report in Power BI
                \n<\/strong><\/p>\n
                \/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\r\n\/\/ Change _GET_MERCHANT_LISTINGS_DATA_ to something else if you need different report type (all 3 steps) -- https:\/\/docs.developer.amazonservices.com\/en_US\/reports\/Reports_ReportType.html\r\n\/\/ Replace MarketplaceId in all 3 steps (i.e for USA use ATVPDKIKX0DER) --https:\/\/docs.developer.amazonservices.com\/en_US\/dev_guide\/DG_Endpoints.html\r\n\/\/ Replace SellerId in all 3 steps\r\n\/\/ Remove or Change CreatedAfter in first step (or use CreatedBefore parameter instread of CreatedAfter)\r\n\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\r\n\r\nlet\r\n    sql=\"SELECT s3.* FROM $\r\nWITH(\r\nSrc='https:\/\/mws.amazonservices.com\/Reports\/2009-01-01',RequestMethod='POST'\r\n,RequestData='Action=RequestReport&ReportType=_GET_MERCHANT_LISTINGS_DATA_&MarketplaceId=ATVPDKIKX0DER&SellerId=Axxxxxxxxxx&CreatedAfter=2017-12-31T04%3A00%3A00Z'\r\n,IncludeParentColumns='False'\r\n,EnableRawOutputModeSingleRow='True'\r\n,RawOutputFilterExpr='\/\/*[local-name()=\"\"ReportRequestId\"\"]' \r\n,RawOutputDataRowTemplate='{ReportRequestId:\"\"[$1]\"\"}' \r\n,RawOutputExtractMode='Xml' \r\n,WaitTimeMs=5000\r\n,Meta='[{\"\"Name\"\": \"\"ReportRequestId\"\",\"\"Type\"\": \"\"Int64\"\"}]'\r\n,Alias='s1'\r\n\r\n,Join1_alias='s2'\t\r\n,Join1_Src='https:\/\/mws.amazonservices.com\/Reports\/2009-01-01',Join1_RequestMethod='POST'\r\n,Join1_RequestData='Action=GetReportRequestList&ReportRequestIdList.Id.1=[$s1.ReportRequestId$]&MarketplaceId=ATVPDKIKX0DER&SellerId=Axxxxxxxxxx'\r\n,Join1_EnableRawOutputModeSingleRow='True'\r\n,Join1_RawOutputFilterExpr='\/\/*[local-name()=\"\"ReportProcessingStatus\"\"]||\/\/*[local-name()=\"\"GeneratedReportId\"\"]' \r\n,Join1_RawOutputDataRowTemplate='{ReportProcessingStatus:\"\"[$1]\"\",GeneratedReportId:\"\"[$2]\"\"}' \r\n,Join1_RawOutputExtractMode='Xml' \r\n,Join1_EnableStatusCheck='True', \r\n,Join1_StatucCheckMaxWaitSeconds=300,\r\n,Join1_StatucCheckIterationWaitSeconds=25,\r\n,Join1_StatusSuccessValue='_DONE_'\r\n,Join1_StatusFailedValue='_DONE_NO_DATA_|_CANCELLED_'\r\n\r\n,Join2_Alias='s3'\r\n,Join2_Src='https:\/\/mws.amazonservices.com\/Reports\/2009-01-01',Join2_RequestMethod='POST'\r\n,Join2_RequestData='Action=GetReport&ReportId=[$s2.GeneratedReportId$]&MarketplaceId=ATVPDKIKX0DER&SellerId=Axxxxxxxxxx'\t\r\n,Join2_ColumnDelimiter='{TAB}'\r\n,Join2_ResponseCharset='Windows-1252'\t \r\n,Join2_EnableStatusCheck='False' \r\n,Join2_EnableRawOutputModeSingleRow='False'\r\n)\",\r\n    Source = Odbc.Query(\"dsn=ZS-AMAZON-MWS-CSV\", sql)\r\nin\r\n    Source<\/pre>\n
                 <\/p>\n
                <\/p>\n
                Power BI M Script (Old Driver) – v1.1.2 or older<\/p>\n
                <\/strong>If you are using older version – v1.1.2 or older then use below script.<\/p>\n
                \/*\r\n All Copy Rights Reserved - ZappySys LLC. Feel free to share this snippet as long as you retain copyrights notice. https:\/\/zappysys.com\r\n Description:  This snippet will call Amazon MWS API to generate Inventory Report (Its multi step process - Job Style API call. First 2 calls gets XML data and Last call CSV data)\r\n*\/\r\n\r\nlet\r\n    \/\/NOTE: In Power BI M Language... each declare is separated by comma... \r\n    \/\/variable can be any type.. string, number, table, list , record, function reference. More info: https:\/\/docs.microsoft.com\/en-us\/powerquery-m\/power-query-m-reference\r\n    \/* \r\n    let \r\n        var1=expression, var2=expression,  ... varN=expression\r\n    in\r\n        varN   \/\/return some variable\r\n    *\/\r\n\r\n    \/\/define some common variables\r\n\r\n    MarketplaceId=\"A1xxxxxx\",\r\n    SellerId=\"A2xxxxxxxxxx\",\r\n\r\n    \/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\r\n    \/*Step-1 : Send new report request  - Must use XML Driver *\/\r\n    \/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\r\n\r\n    Step1Sql=\"SELECT ReportRequestId FROM $\r\nWITH(\r\n    --Src='c:\\temp\\reportrequest.txt'\r\n    Src='https:\/\/mws.amazonservices.com\/Reports\/2009-01-01'\r\n\t--,ElementsToTreatAsArray='Product'\r\n\t,Filter='$.RequestReportResponse.RequestReportResult.ReportRequestInfo'\r\n\t,RequestData='Action=RequestReport&ReportType=_GET_MERCHANT_LISTINGS_DATA_&MarketplaceId=\" & MarketplaceId & \"&SellerId=\" & SellerId & \"'\r\n\t,RequestMethod='POST'\r\n\t,WaitTimeMs='300'\r\n\t,IncludeParentColumns='False'\r\n\t,CachingMode='All'\r\n\t,CacheStorage='File'\r\n\t,CacheFileLocation='c:\\temp\\mws-step1.cache'\r\n\t,CacheEntryTtl=300\r\n\t,Meta='[{\"\"Name\"\": \"\"ReportRequestId\"\",\"\"Type\"\": \"\"Int64\"\"}]'\r\n)\",\r\n    Source1 = Odbc.Query(\"dsn=ZAPPY-MWS-API-XML\", Step1Sql),\r\n    ReportRequestId= Source1{0}[ReportRequestId],\r\n    \r\n    \/\/NOTE: Technically we need to implement status check loop Wait for few seconds before \r\n    \/\/Increase this if you get ERROR in 3rd step\r\n    BlankTextForDelay = Function.InvokeAfter(()=>\"\", #duration(0,0,0,15)), \/\/define delay - You must use it somewhere inorder to invoke delay\r\n\r\n    \/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\r\n    \/*Step-2 : Get report id - once report is done  - Must use XML Driver *\/\r\n    \/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\r\n    Step2Sql=BlankTextForDelay & \"SELECT *  FROM $\r\nWITH(\r\n    --Src='c:\\temp\\report-status.xml'\r\n    Src='https:\/\/mws.amazonservices.com\/Reports\/2009-01-01'\r\n\t,ElementsToTreatAsArray='ReportRequestInfo'\r\n\t,Filter='$.GetReportRequestListResponse.GetReportRequestListResult.ReportRequestInfo'\r\n\t,RequestData='Action=GetReportRequestList&ReportRequestIdList.Id.1=\" &  ReportRequestId & \"&MarketplaceId=\" & MarketplaceId & \"&SellerId=\" & SellerId & \"'\r\n\t,RequestMethod='POST'\r\n\t,WaitTimeMs='300'\r\n\t,IncludeParentColumns='False'\r\n\t,CachingMode='All'\r\n\t,CacheStorage='File'\r\n\t,CacheFileLocation='c:\\temp\\mws-step2.cache'\r\n\t,CacheEntryTtl=15\r\n\t,Meta='[{\"\"Name\"\": \"\"ReportProcessingStatus\"\",\"\"Type\"\": \"\"String\"\", Length: 100},{\"\"Name\"\": \"\"GeneratedReportId\"\",\"\"Type\"\": \"\"Int64\"\"}]'\r\n)\",    \r\n    Source2 = Odbc.Query(\"dsn=ZAPPY-MWS-API-XML\", Step2Sql),\r\n    ReportId= Source2{0}[GeneratedReportId],\r\n\r\n\r\n    \/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\r\n    \/*Step-3 : Get report data in CSV format - Must use CSV Driver *\/\r\n    \/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\r\n    Step3Sql=\"SELECT * FROM $\r\nWITH(\r\n       --Src='c:\\temp\\inventory.csv.txt'\r\n\t Src='https:\/\/mws.amazonservices.com\/Reports\/2009-01-01'\r\n\t,RequestData='Action=GetReport&ReportId=\" &  ReportId & \"&MarketplaceId=\" & MarketplaceId & \"&SellerId=\" & SellerId & \"'\r\n\t,RequestMethod='POST'\r\n\t,WaitTimeMs='300'\r\n\t,ColumnDelimiter='{TAB}'\r\n\t,CachingMode='All'\r\n\t,CacheStorage='File'\r\n\t,CacheFileLocation='c:\\temp\\mws-step3.cache'    \r\n\t,ResponseCharset='Windows-1252'\t    \r\n\t)\",    \r\n    Source3 = Odbc.Query(\"dsn=AMAZON-MWS-CSV\", Step3Sql)\r\n\r\nin\r\n    Source3  \/\/return Source3 (i.e. Table type variable)<\/pre>\n
                 <\/li>\n
              7. Once done click OK<\/strong>.<\/li>\n
              8. You may be prompted few times to trust each Query we defined in M Script above. Also you may be prompted to select DSN Credentials (Just Select Windows Credentials<\/strong>)\n
              9. If you get prompted to select DSN Credentials then select as below (Click Windows<\/strong>).\n
              10. After few seconds (Depending on Delay we define in Script – default 15 sec) you will see data loaded.<\/li>\n
              11. Once data is loaded click Close & Apply and it will close the query editor and we will see main designer where you can see Dataset and Fields we just created.\n
                \"Loading<\/a>
                Loading Amazon MWS Reports data in Power BI (List Inventory Example using M Script)<\/p><\/div><\/li>\n<\/ol>\n
                Conclusion<\/h2>\n
                In this article, we saw how to build sales report by reading data from your Amazon Seller Account. We used simple SQL queries with ZappySys XML Driver to pull data from Amazon MWS API.\u00a0ZappySys ODBC PowerPack<\/a> makes it super easy to consume data from virtually any API (JSON \/ XML or CSV Web Services), no coding required. Download here<\/a> to get started with ZappySys ODBC drivers.<\/p>\n
                 <\/p>\n","protected":false},"excerpt":{"rendered":"
                Introduction In our previous blog we saw how to call REST API in Power BI to import data from JSON based REST API services. Now let’s continue on that and learn how to import Amazon MWS data in Power BI using XML driver. To learn more about how to consume Amazon MWS data in ETL […]<\/p>\n","protected":false},"author":1,"featured_media":1632,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[276,335,278],"tags":[151,279,7],"yoast_head":"\r\nHow to Import Amazon MWS data in Power BI | ZappySys Blog<\/title>\r\n<meta name=\"description\" content=\"Learn how to import Amazon MWS data in Power BI dashboard using ZappySys XML Driver.\" \/>\r\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\r\n<link rel=\"canonical\" href=\"https:\/\/zappysys.com\/blog\/import-amazon-mws-data-power-bi\/\" \/>\r\n<meta property=\"og:locale\" content=\"en_US\" \/>\r\n<meta property=\"og:type\" content=\"article\" \/>\r\n<meta property=\"og:title\" content=\"How to Import Amazon MWS data in Power BI | ZappySys Blog\" \/>\r\n<meta property=\"og:description\" content=\"Learn how to import Amazon MWS data in Power BI dashboard using ZappySys XML Driver.\" \/>\r\n<meta property=\"og:url\" content=\"https:\/\/zappysys.com\/blog\/import-amazon-mws-data-power-bi\/\" \/>\r\n<meta property=\"og:site_name\" content=\"ZappySys Blog\" \/>\r\n<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/ZappySys\/\" \/>\r\n<meta property=\"article:published_time\" content=\"2018-09-14T15:24:15+00:00\" \/>\r\n<meta property=\"article:modified_time\" content=\"2026-03-11T07:08:28+00:00\" \/>\r\n<meta property=\"og:image\" content=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2016\/10\/amazon-mws-api-integration.png\" \/>\r\n\t<meta property=\"og:image:width\" content=\"505\" \/>\r\n\t<meta property=\"og:image:height\" content=\"505\" \/>\r\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\r\n<meta name=\"author\" content=\"ZappySys\" \/>\r\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\r\n<meta name=\"twitter:creator\" content=\"@https:\/\/twitter.com\/zappysys\/\" \/>\r\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"ZappySys\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"19 minutes\" \/>\r\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/zappysys.com\/blog\/import-amazon-mws-data-power-bi\/\",\"url\":\"https:\/\/zappysys.com\/blog\/import-amazon-mws-data-power-bi\/\",\"name\":\"How to Import Amazon MWS data in Power BI | ZappySys Blog\",\"isPartOf\":{\"@id\":\"https:\/\/zappysys.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/zappysys.com\/blog\/import-amazon-mws-data-power-bi\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/zappysys.com\/blog\/import-amazon-mws-data-power-bi\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2016\/10\/amazon-mws-api-integration.png\",\"datePublished\":\"2018-09-14T15:24:15+00:00\",\"dateModified\":\"2026-03-11T07:08:28+00:00\",\"author\":{\"@id\":\"https:\/\/zappysys.com\/blog\/#\/schema\/person\/2756c237457fbc95d82cb38962f81f82\"},\"description\":\"Learn how to import Amazon MWS data in Power BI dashboard using ZappySys XML Driver.\",\"breadcrumb\":{\"@id\":\"https:\/\/zappysys.com\/blog\/import-amazon-mws-data-power-bi\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/zappysys.com\/blog\/import-amazon-mws-data-power-bi\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/zappysys.com\/blog\/import-amazon-mws-data-power-bi\/#primaryimage\",\"url\":\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2016\/10\/amazon-mws-api-integration.png\",\"contentUrl\":\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2016\/10\/amazon-mws-api-integration.png\",\"width\":505,\"height\":505},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/zappysys.com\/blog\/import-amazon-mws-data-power-bi\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/zappysys.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to Import Amazon MWS data in Power BI\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/zappysys.com\/blog\/#website\",\"url\":\"https:\/\/zappysys.com\/blog\/\",\"name\":\"ZappySys Blog\",\"description\":\"SSIS \/ ODBC Drivers \/ API Connectors for JSON, XML, Azure, Amazon AWS, Salesforce, MongoDB and more\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/zappysys.com\/blog\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/zappysys.com\/blog\/#\/schema\/person\/2756c237457fbc95d82cb38962f81f82\",\"name\":\"ZappySys\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/zappysys.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/5c9be148088ba9b8af8e955c5f7c22b5?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/5c9be148088ba9b8af8e955c5f7c22b5?s=96&d=mm&r=g\",\"caption\":\"ZappySys\"},\"sameAs\":[\"http:\/\/www.zappysys.com\/\",\"https:\/\/www.facebook.com\/ZappySys\/\",\"https:\/\/twitter.com\/https:\/\/twitter.com\/zappysys\/\"],\"url\":\"https:\/\/zappysys.com\/blog\/author\/admin\/\"}]}<\/script>\r\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to Import Amazon MWS data in Power BI | ZappySys Blog","description":"Learn how to import Amazon MWS data in Power BI dashboard using ZappySys XML Driver.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/zappysys.com\/blog\/import-amazon-mws-data-power-bi\/","og_locale":"en_US","og_type":"article","og_title":"How to Import Amazon MWS data in Power BI | ZappySys Blog","og_description":"Learn how to import Amazon MWS data in Power BI dashboard using ZappySys XML Driver.","og_url":"https:\/\/zappysys.com\/blog\/import-amazon-mws-data-power-bi\/","og_site_name":"ZappySys Blog","article_author":"https:\/\/www.facebook.com\/ZappySys\/","article_published_time":"2018-09-14T15:24:15+00:00","article_modified_time":"2026-03-11T07:08:28+00:00","og_image":[{"width":505,"height":505,"url":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2016\/10\/amazon-mws-api-integration.png","type":"image\/png"}],"author":"ZappySys","twitter_card":"summary_large_image","twitter_creator":"@https:\/\/twitter.com\/zappysys\/","twitter_misc":{"Written by":"ZappySys","Est. reading time":"19 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/zappysys.com\/blog\/import-amazon-mws-data-power-bi\/","url":"https:\/\/zappysys.com\/blog\/import-amazon-mws-data-power-bi\/","name":"How to Import Amazon MWS data in Power BI | ZappySys Blog","isPartOf":{"@id":"https:\/\/zappysys.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/zappysys.com\/blog\/import-amazon-mws-data-power-bi\/#primaryimage"},"image":{"@id":"https:\/\/zappysys.com\/blog\/import-amazon-mws-data-power-bi\/#primaryimage"},"thumbnailUrl":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2016\/10\/amazon-mws-api-integration.png","datePublished":"2018-09-14T15:24:15+00:00","dateModified":"2026-03-11T07:08:28+00:00","author":{"@id":"https:\/\/zappysys.com\/blog\/#\/schema\/person\/2756c237457fbc95d82cb38962f81f82"},"description":"Learn how to import Amazon MWS data in Power BI dashboard using ZappySys XML Driver.","breadcrumb":{"@id":"https:\/\/zappysys.com\/blog\/import-amazon-mws-data-power-bi\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/zappysys.com\/blog\/import-amazon-mws-data-power-bi\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/zappysys.com\/blog\/import-amazon-mws-data-power-bi\/#primaryimage","url":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2016\/10\/amazon-mws-api-integration.png","contentUrl":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2016\/10\/amazon-mws-api-integration.png","width":505,"height":505},{"@type":"BreadcrumbList","@id":"https:\/\/zappysys.com\/blog\/import-amazon-mws-data-power-bi\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/zappysys.com\/blog\/"},{"@type":"ListItem","position":2,"name":"How to Import Amazon MWS data in Power BI"}]},{"@type":"WebSite","@id":"https:\/\/zappysys.com\/blog\/#website","url":"https:\/\/zappysys.com\/blog\/","name":"ZappySys Blog","description":"SSIS \/ ODBC Drivers \/ API Connectors for JSON, XML, Azure, Amazon AWS, Salesforce, MongoDB and more","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/zappysys.com\/blog\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/zappysys.com\/blog\/#\/schema\/person\/2756c237457fbc95d82cb38962f81f82","name":"ZappySys","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/zappysys.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/5c9be148088ba9b8af8e955c5f7c22b5?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/5c9be148088ba9b8af8e955c5f7c22b5?s=96&d=mm&r=g","caption":"ZappySys"},"sameAs":["http:\/\/www.zappysys.com\/","https:\/\/www.facebook.com\/ZappySys\/","https:\/\/twitter.com\/https:\/\/twitter.com\/zappysys\/"],"url":"https:\/\/zappysys.com\/blog\/author\/admin\/"}]}},"_links":{"self":[{"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/posts\/4825"}],"collection":[{"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/comments?post=4825"}],"version-history":[{"count":32,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/posts\/4825\/revisions"}],"predecessor-version":[{"id":11867,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/posts\/4825\/revisions\/11867"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/media\/1632"}],"wp:attachment":[{"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/media?parent=4825"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/categories?post=4825"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/tags?post=4825"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}