Power BI 12 Days of Dashboards – Day 5 – Amazon.com Order History Dashboard


Amazon Power BI Dashboard

Day #5 – Amazon.com Order History Dashboard

As part of my Power BI 12 Days of Dashboards series, the 5th day of dashboards brings you an easy way to view your Amazon.com Order History. I built this with a single year of data, but you could extend this to view history from multiple years for additional insight into your order history.

Here is a fictitious example of the dashboard. You can easily create your own order dashboard by following the steps below.

 

 

The first step to creating this dashboard is to export your order history from Amazon.com.

  1. Navigate to www.amazon.com and click on “Your Account”
  2. Under the heading “Order History”, click on “Download Order Report”
  3. The next screen will allow you to select which data to export and the date range desired. Keep the report type set to Items to get the breakdown of categories in the dashboard above. Make your selection and click on “Request Report”. The report will be processed and will appear in your report list below. Download this .csv file to your local machine to use as the data source in the Power BI template in the next step.

Next, download the Power BI Template from here and continue with the following steps:

  1. Download and open the attached AmazonOrdersTemplate.pbit file and open it in Power BI Desktop
  2. A popup box appears asking for the full path of the .csv file exported in the above steps. Provide the full path to the file on your computer and click the “Load” button in the bottom right. (TIP: Make sure the file is closed or you’ll hit an error here. If so, close the file and relaunch the Power BI template)

Thanks,
Sam Lester (MSFT)

Comments (6)

  1. Yoshihiro Kawabata says:

    Wow, nice.
    I will try this report by my amazon order history.
    Thank you.

  2. Frederik Colmorgen says:

    Too bad amazon.de doesn’t have this feature 🙁

    1. Hi Frederik, that’s interesting, thanks for pointing that out. I also tried it with my Amazon.de account and see that the export functionality does not exist. The direct .com URL for exporting the report is https://www.amazon.com/gp/b2b/reports. When I change the URL to https://www.amazon.de/gp/b2b/reports, I can view the export page, but get an error stating “We encountered an error while submitting your request, please try again”.

  3. Michael Pointeau says:

    Hey. I am happy for you that you can export in your current country. I was trying to run this a year ago, as I was curious to track and analyze my growing orders into Amazon and didn’t find any way to export Orders History from Amazon. Looking at your dashboard, I was excited that it would be now accessible.
    Unfortunately as mentionned already by Frederik and to which you replied, I am also unlucky registered of France Amazon so I can’t either access by download to my order history. 🙁
    I have contacted Amazon and they say they are independant sites and this is not (yet) offered for us. Support Agent has escaladed the request to appropriate Services

  4. BG says:

    Receiving the follow error – DataSource.Error: Access to path C:\xxxxxx\xxxxxx is denied.
    The CSV file is not open and I’ve tried moving the CSV to several different locations, but the same error persists.

    1. MLB says:

      I am having the same problem of DataSource.Error: Access to path ‘C:\xxxx\xxx’ is denied. The file is not read-only, so I don’t know how to resolve it.

Skip to main content