Articles on: Catchr

How to create a request for PowerBI / Tableau / CSV / JSON ?

How do you create a request for PowerBI / Tableau / CSV / JSON ?


Once you have added a source on Catchr, you can create requests a request to get your data into PowerBI or Tableau or get a stream in CSV or JSON format.

How to create a new request ?


Go to the [API](https://app.catchr.io/data-connector/api) menu.
Select your output format at the top left:
Select your output type for the request.
Select your platform (click on the "+" to add a new account for this platform or on the platform name to select it).
Select your platform or create a new Source.
Select one or multiple accounts.
Select your accounts.
Select your metrics (some platforms do not have metrics; this step does not appear then).
Select some metrics.
Select your dimensions.
Select some dimensions
Select your date range.
Choose a predefined or a custom date range.
Apply filters (an AND logical operator separates multiple filters).
Apply filters if necessary (optionnal).
Apply options if necessary (if nothing is used in the options, we will take the platform default options).
Apply some options (optionnal).
Clicks Preview at the top right to test your new request.
Preview your request to check it is working (optionnal)
Successful request example.

If the request is successful, the next step is to copy the generated URL. This URL can then be used on your desired destination, such as PowerBI or Tableau, to import the data or generate a stream in the chosen format.
If the request is unsuccessful, try removing some fields, the major issue is caused because some fields cannot be mixed up (it is usually a bad idea to add all the fields and launch the preview) or write to for advice.

Here is a video tutorial for PowerBI.
Here is a video tutorial for Tableau.

Updated on: 29/08/2024

Was this article helpful?

Share your feedback

Cancel

Thank you!