> For the complete documentation index, see [llms.txt](https://pathta.gitbook.io/pathta-docs/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://pathta.gitbook.io/pathta-docs/reporting/create-a-reporting-path.md).

# Create a reporting Path

{% hint style="info" %}
A reporting path allows you to see your data on Looker Studio, Microsoft Power BI or Excel

You have to create one Path by table you want to see
{% endhint %}

{% embed url="<https://www.tella.tv/video/reporting-path-9t5i>" %}
Create a reporting Path
{% endembed %}

{% stepper %}
{% step %}

### <mark style="color:red;">STEP 1</mark>

Create a reporting Path
{% endstep %}

{% step %}

### <mark style="color:red;">STEP 2</mark>

Select or add a data source
{% endstep %}

{% step %}

### <mark style="color:red;">STEP 3</mark>

Choose the fields you want to visualize and publish your reporting path
{% endstep %}

{% step %}

### <mark style="color:red;">STEP 4</mark>

Open your Power BI tool, Looker Studio or Excel
{% endstep %}
{% endstepper %}

## 1. Create a reporting path

Choose a path name an the type Reporting and click on Create path

<figure><img src="https://1039087027-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FKMgBZ3wq0SUPGSqOmR9C%2Fuploads%2F7OdKwSI4hoOG4EqB4D2h%2Fimage.png?alt=media&amp;token=42c4ee50-f4e2-4e81-a16f-9f305a27dbc5" alt=""><figcaption><p>Choose a name and select Reporting path</p></figcaption></figure>

## 2. Select or add your data source

Select an extisting data source or create a new data source for your data.\
Select a database and then select a table of the data base or a view if the source manage views.

<figure><img src="https://1039087027-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FKMgBZ3wq0SUPGSqOmR9C%2Fuploads%2FZEoRs8EoiqKCfC46aAz3%2Fimage.png?alt=media&amp;token=68540d72-72a3-4a59-be4d-e35deba06508" alt=""><figcaption></figcaption></figure>

## 3. Choose the fields you want to visualize

Select one or more fields que want to see on Looker Studio or in Power BI.

<figure><img src="https://1039087027-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FKMgBZ3wq0SUPGSqOmR9C%2Fuploads%2F4i9PxU426oOf8caVNH9I%2Fimage.png?alt=media&amp;token=e868ddba-0cef-487c-b09f-4e01eaefe1f1" alt=""><figcaption><p>Select one or more field</p></figcaption></figure>

Copy the token (for the first use in Looker Studio or in Power BI) and publish you path

<figure><img src="https://1039087027-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FKMgBZ3wq0SUPGSqOmR9C%2Fuploads%2F0nx4eRlbCqIGdaOBM70L%2Fimage.png?alt=media&amp;token=ed8598b2-30d8-4802-af67-f2b144be858c" alt=""><figcaption><p>Check you path, publish it and copy paste the token</p></figcaption></figure>

## 4. Open your BI tool : Power BI, Looker Studio or Excel

For Power BI see this [documentation](/pathta-docs/reporting/see-your-data-on-power-bi-with-pathta-connector.md)\
For Looker studio see this [documentation](/pathta-docs/reporting/see-your-data-on-data-studio.md)