connectivity with Google Ads, Google Analytics and SEMrush data sources

[powerbiexpert22]

Can Power BI connect with Google Ads, Google Analytics and SEMrush data sources?

[v-pgoloju]

Hi @powerbiexpert22,

Just following up to see if the Response provided was helpful in addressing the issue. if the issue still persists Feel free to reach out if you need any further clarification or assistance.

Best regards,
Prasanna Kumar

[v-pgoloju]

Hi @powerbiexpert22,

Thank you for reaching out to the Microsoft Fabric Forum Community, and special thanks to @grazitti_sapna  for prompt and helpful responses.

Power BI doesn’t have a built-in connector for Google Ads or SEMrush, but there are other ways to bring their data in. You can use each platform’s API to pull the data directly into Power BI through Power Query (though this requires some setup and authentication). Another reliable option is to first move the data into a data warehouse like Google BigQuery or Azure SQL using Google’s transfer tools or scripts, and then connect Power BI to that warehouse. If your Google Ads is linked with Google Analytics, you can also get some Ads data through the existing Google Analytics connector.

Best regards,
Prasanna Kumar

[grazitti_sapna]

Hi @powerbiexpert22,

• Power BI provides a native connector for Google Analytics (though depending on which version, GA3 / Universal / GA4, there are different APIs / endpoints).

• You can fetch metrics & dimensions, build reports, schedule refreshes, etc.

• n practice, many users move GA4 data into a data warehouse (e.g. BigQuery) and then connect Power BI, to get better control and scale.

There is no built-in, first-party connector in Power BI for Google Ads (i.e. Microsoft does not ship a default “Google Ads” connector).

• Third-party connectors / drivers, e.g. CData’s Google Ads Connector for Power BI. CData Software+1

• ETL / integration platforms (e.g. Windsor.ai, Coupler.io) to pull data from Google Ads and push into Power BI (or into a database that Power BI reads from). windsor.ai+2Coupler.io Blog+2

• Use Google’s API directly with Power Query (via M / custom connector) — more development work.

• SEMrush API — they provide API access (if your SEMrush plan supports it). You can use Power Query (Web.Contents etc.) to call the SEMrush API, pull data, transform, and load. blog.dataddo.com+2developer.semrush.com+2

• Third-party connector / ETL tool like Supermetrics, Precog, Improvado, Funnel, etc. — these tools let you extract SEMrush data and pipe it into a destination that Power BI can ingest (database, API, etc.). supermetrics.com+3Precog+3improvado.io+3

Alternatively you can store the data from all this sources to a data warehouse and connect them to Power BI

🌟 I hope this solution helps you unlock your Power BI potential! If you found it helpful, click 'Mark as Solution' to guide others toward the answers they need.
💡 Love the effort? Drop the kudos! Your appreciation fuels community spirit and innovation.
🎖 As a proud SuperUser and Microsoft Partner, we’re here to empower your data journey and the Power BI Community at large.
🔗 Curious to explore more? [Discover here].
Let’s keep building smarter solutions together!