Connect LinkedIn Ads to Power BI

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

Step 1: Collect data
First, connect your LinkedIn Ads account. Next, select specific ad accounts to export data from, the type of report you need, the reporting period, metrics, and the dimension required.



After you adjust the data source settings, proceed to the next step.

Step 2: Organize and transform
Verify the accuracy of your data before you load LinkedIn Ads to Power BI. If adjustments are necessary, explore the various transformation options available:

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

This approach guarantees that you can proceed directly to analytics without modifying your imported data.



This step is essential to make your data analysis-ready.

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



Then, activate and schedule automated data refresh. Your final click will be to save and run the importer.

Enable automated refreshes to guarantee continuous updates for your imported data. Customize frequency based on your preferences, choosing from options such as monthly, daily, or hourly to intervals as frequent as every 30 or 15 minutes. You also have the flexibility to select specific days, the time slot, and the time zone.



With this feature, your report remains synchronized with the constantly updating LinkedIn ads data. So you can always access timely and relevant information.