blog post

How to use Power BI with Catchr ?

Johan Chemin
September 11, 2024
How to use Power BI with Catchr ?

Quick steps to create a report with Google Sheets:

You can easiliy create a report following this step :

  1. Get informations from the data integration from our connector.
  2. Create a source on catchr.io.
  3. Download our Google Sheets extensions.
  4. Configure and run your request
If you need more informations, you can follow the tutorial.

How to install Google Sheets Catchr Add-on.

To start exporting your data to Google Sheets, you need to install the Catchr add-on. You currently have two options :

Option A: Via the marketplace:

  1. Visit the Catchr Add-on page on the Google Workspace Marketplace and click "Install."
  2. Grant the necessary permissions for the add-on.
  3. Upon successful installation, open a Google Sheets to proceed.
Connect Google Sheet to Facebook Ads
Install Catchr Google Sheets Add-on

Option B: Directly within a Google Sheets:

  1. Open a new Google Sheets.
  2. In the top menu, click "Extensions", then hover over "Add-ons" and select "Get add-ons."
  3. Search for "Catchr" and choose "Catchr - data connector."
  4. Click "Install" and grant the required permissions.
  5. Close the installation pop-up when completed.
  6. Start using the Catchr add-on.
Install Catchr Add-on for Google Sheets
Install Catchr Add-on for Google Sheets

Once you have installed the add-on, you can start making requests.

The tutorial

Quick steps to create a report with Looker Studio:

You can easiliy create a report following this step :

  1. Get informations from the data integration from our connector.
  2. Create a datasource and new report on Looker Studio.
  3. Choose your metrics and dimensions.
  4. Use charts with your metrics and dimensions.
If you need more informations, you can follow the tutorial. You can also find a template for at the end of the page.

The tutorial

Quick steps to create a report with PowerBI:

You can easiliy create a report following this step :

  1. Get informations from the data integration from our connector.
  2. Create a source on catchr.io.
  3. Configure your request on the PowerBI request manager.
  4. Copy the given URL in PowerBI
If you need more informations, you can follow the tutorial. You can also find a template for at the end of the page.

The tutorial

Are you interested in using Catchr on PowerBI? Great! 

PowerBI is one of the most complete dashboarding tools that currently exist. With its two solutions, the PowerBI desktop and the PowerBI Web App, everyone can access it. 

  • PowerBI Desktop is oriented for report creators and data analysts. You can create fantastic reports and dig into your data quickly. 
  • PowerBI Web App is more user-friendly for any non-technical person who wishes to create or consult a report with little data manipulation.

Combined with Catchr, you can easily connect and transfer data into PowerBI, quickly create stunning reports and dashboards, aggregate every platform data in one place, and share your excellent dashboard with your team and client.

You can even save time using one of our pre-made and ready-to-use templates. They are all free to download and fully customizable to fit your needs!

How to use PowerBI with Catchr

To get started, you first need an account on Catchr! Follow this link to subscribe (we have a 14-day free trial period, no credit card required, no engagement).

Then, download PowerBI Desktop, install it, and create your Microsoft account to log in to PowerBI.

Once done, go back to Catchr. You need to add a Source on Catchr to link your platform account and generate the request URL for PowerBI:

Add a source. 

On the Catchr homepage, go to Source, then Add a Source at the top right.

Select the platform you want and go through the identification step to connect Catchr and the selected platform.

Add a new source on Catchr
Add a new source on Catchr

Accounts you manage will appear after a short time of synchronization. Once they are here, it's time to create your request.

Example of MetaAds account list on Catchr

Create your request for PowerBI.

Now, go to API in the left menu.

  • First, select PowerBI at the top left:
First step of creating your query in app.catchr.io: select PowerBI to generate the PowerBI request.First step of creating your query in app.catchr.io: select PowerBI to generate the PowerBI request.First step of creating your query in app.catchr.io: select PowerBI to generate the PowerBI request.
Select PowerBI to generate the PowerBI request.
  • Then select your platform (if you want to add a new account to a platform, click on the "+", else, click on the platform name). 
  • And Select your account.
Select your account
Select your account.
  • Select your metrics and dimensions. 
Select your metrics
Select your metrics

Warning: If you use one of our templates, select all the required dimensions and metrics listed on the template's page on Catchr. If done correctly, the template will load automatically with all your data. You can then customize it to fit your specific needs.

  • Select the period.
Select the date range you want to report.
Select the date range you want to report.
  • Select your filters (you can skip this step if you don't want to filter your data).
Create your filter
Create your filter. Just skip this step if you do not want to filter your data.

Great, now double-click on the generated URL at the top of the page and copy it.

Keep it. It's the first thing PowerBI will ask when you open a template.

PowerBI Desktop

In PowerBI Desktop, you can import data from various data sources. Here, we will need a web data source to import data from a web page.

Go to :

  • Get Data, then Web.
  • Stay in basics mode and paste the request URL you generated in the previous step.
  • Click OK.
Add a new data set import from web.

Paste the URL you got on Catchr and click OK.

PowerBI can take a few minutes to import your data. Once done, you can use PowerBI Query to edit the query and work your field type. Then, you can start creating your dashboard with your data and publish and share it with everyone you need.

If you need to use a data set in the PowerBI Web App, publish it to access it on your browser.

PowerBI Web App

To find a data set on the PowerBI web app, import it from the PowerBI desktop and then use it on the web app. Follow the previous step to learn how to publish your web data source from PowerBI Desktop.

You can then go to New Report and Pick a published data set. You will find all your printed data sets and will be able to use them to create your new report.

{{cta-template-powerbi}}

Open a PowerBI template.

Double-click on the template file (.pbi) you downloaded from one of our template pages, and it will open PowerBI.

The first thing asked is the Request URL. Paste it. Then click on Load.

Open a template in PowerBI
Open a template in PowerBI

Depending on the volume of data to load, this can take a few minutes.

Once finished, you can customize your new report to fit your needs and share it with your co-workers or clients.

Empower your Marketing data analysis
Discover +50 connectors to import your Marketing data into your favorite dashboard tool! Unlock instant data integration with Catchr's no-code feature – no IT team required!
Start your free trial!

All your marketing data on Power BI

Build Power BI dashboard with your different marketing data and track all the essential KPIs.

Start your free trial!
Keep an eye on your data
No items found.
Need a clearer view of your marketing data?
Unlock your free Looker Studio dashboard template for from a collection of +50 stunning designs. Elevate your data visualization!
Get it for free
Need a clearer view of your marketing data?
Unlock your free Power BI dashboard template from a collection of stunning designs. Elevate your data visualization!
Get it for free
Need a clearer view of your marketing data?
No items found.
No items found.
Need a clearer view of your marketing data?
No items found.
No items found.
No items found.

In this template, you will find all the metrics and dimensions you would need to get a better view of your data.

If you need more templates, you could look at our looker studio template gallery.

No items found.

In this template, you will find all the metrics and dimensions you would need to get a better view of your data thank to our integrations.

If you need more templates, you could look at our PowerBI template gallery.

Unlock Insights with Style!

Transform your marketing data into stunning dashboards.

Integrate, visualize, and impress with Catchr's seamless dashboards. Elevate your data game now!
Build your first report
14 days free-trial - No credit card required 🎉

More blog post about

No items found.