Skip to main content
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now


How to get your Facebook Ads, Google Ads, and other data to Power BI

Almost all modern CRM, EPR software, and social platforms have a possibility to get, store and analyze the data. However, if you want to, you can always download them from the source and analyze them yourself. For that, you can use the tools of your choice. Many times, the choice is Power BI.


Get all of your data

The problem arises when you want to use the data from multiple sources, Google Ads, Facebook Ads, CRM software like Salesforce, etc.

Also, you would like to have the most recent data. For that purpose, you will need to get the data online through a piece of software – Connector. It enables you to, well, connect to your data sources and get the data into your reporting and visualization tool.

Some platforms provide their users with connectors, but most do not.

It gives rise to services that are doing just that. They made connectors for many different data sources, and through their service, enable you to collect all your data.


OK, once you get the data, what then?

So, how to get your data from Facebook Ads, Google Ads, and other data to Power BI. If you are using a tool like Power BI, you will need to create your data model and visualizations. Many marketers have some knowledge of how Power BI works. But often do not have enough expertise or simply enough time to develop their own reports.

Services like provide users with templates. They are predefined reports with the most used fields and metrics that most marketers would use. It is often enough for reporting purposes. Sometimes, you can customize the template and add your own data fields choice and visualizations when you need more. A template is, therefore, a helpful tool to get you started.


Power BI template types provides two types of templates. The desktop ones (.pbit) and ones that are, in fact, web Apps, obtainable from the Microsoft AppSource market. In most cases, they are all free to use. The thing you pay, usually after some trial period, is data. The process of gathering and structuring the data is the business where the service provider will do just that. Then, with the help of a template, or some proprietary report, serve the data to you for further analysis.

The templates for Power BI Desktop are known as .pbit files. They do not contain any data, only the structure of query and visualizations definitions, as well as the data model. When you use the template for the first time, you need to enter your API key.


What is API Key?

API Key, in this case, is a service provider key generated in the process of registration to service, kind of password to access your data. In order to use it in this type of service, apart from registering, you will be prompted to grant access to the service provider to your source data, such are Facebook Ads and Google Ads accounts, Google Analytics, and Search Console data, CRM software credentials, etc. The whole idea simply cannot work without you giving those permissions to the service provider to enable them to get the data for you. From their side, companies like fully commit to keeping your data private and secure.


Analyze your data

After entering your API Key and importing your first data, you will save the report as a regular Power BI desktop .pbix file. That file you can then easily publish and have it available for web users from your company. Of course, you will have to have some level of Power BI workings expertise.

Web versions are much less flexible as they do not let you change the data model. They will let you change only some filters and fields. Power BI Web or Power BI Services is a web service that serves end-users without much knowledge of how power BI actually works “under the hood.”

So, if you choose to get the AppSource template app, you will need to use the predefined data model and fields. It all depends on your needs and also the level of your Power BI expertise.



The purpose of data gathering services and the purpose of the templates is to make your work easier. It will let you focus on the substance and not on technicalities like how to get the data, organize the data model, etc. Once you get your Facebook Ads, Google Ads, and other data to Power BI, it leaves you the time to truly immerse yourself in the results and draw the correct conclusions. As a result, it will enable you to improve your marketing campaigns and get your business to a higher level.


Further steps

It is just the beginning of the Power BI reports journey. I have used this approach in some of the reports I have published in Power BI Data Stories Gallery, and I invite you to check them out. Please let me know if this post was clear enough and provided you with the information you need to connect to your data using a third-party vendor template. I will be happy to update this article with the necessary details. Also, you can check for more information on my blog.