Connect Amazon Ads to Power BI

Connect Amazon Ads to Power BI by following three simple steps:

Step 1: Collect data
First, connect your Amazon Ads account. You'll then select the accounts from where to extract data and specify which type of report you need. Next, choose the reporting period and how to split data by period. The last required action at this step is to pick metrics to include in your report.



After that, proceed to the next step.

Step 2: Organize and transform
Before you load Amazon Ads to Power BI, verify the accuracy of your data. If adjustments are necessary, explore the numerous data transformation options that are available:

• Edit, rearrange, hide, or add columns.
• Apply various filters and sort your data.
• Create new columns with custom formulas.
• Combine data from multiple accounts or apps.

This method ensures your data is analytics-ready right after importing, and you won't have to adjust it further.

Once this is done, move on to configuring your destination.

Step 3: Load and automate
To transfer data from Amazon Ads to Power BI, follow the in-app instructions to generate the integration URL and paste it into the Power BI desktop application.



Afterward, go next to set up an automated data refresh. The final step is to save and run the importer.

Enable automated refreshes to ensure your imported Amazon Ads data remains up-to-date at all times. Choose the update interval that best fits your requirements – whether monthly, daily, hourly, or as often as every 30 or 15 minutes. To further personalize the schedule, specify the days of the week, the preferred time frame, and the time zone.



This functionality keeps your report in sync with the ever-changing source data. Consequently, you have access to time-relevant information whenever required.