# Create Looker Studio data source

Remember that **only** **Jira admins have permanent permission to create data sources**. If you're a User, **ensure you've received the necessary permissions** from your Jira administrator before attempting to create a data source. For detailed instructions on how to set up permissions, please visit the [Administration](https://thecode4.gitbook.io/thecode4-docs/administration) page.

***

#### To create a Looker Studio Data Source in our app, follow these steps:

1. **Open Data Processor for Jira**: Navigate to the app within your **Jira Cloud** instance.<br>

   <figure><img src="https://3783386375-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FWbAZwNh39hWp69xdDNc6%2Fuploads%2FMo9f7d3Rmc110TRXfaqz%2F01_navigation_to_app.jpg?alt=media&#x26;token=cdc57bd8-9d17-469e-acac-4432a52e0b43" alt=""><figcaption></figcaption></figure>
2. **Go to** ‘**Data Sources**’ ➡️ ‘**Looker Studio**’: Select the ‘**Data Sources**’ section in the left-side menu, and then choose ‘**Looker Studio**’ from the list.\
   ![](https://3783386375-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FWbAZwNh39hWp69xdDNc6%2Fuploads%2FMB1s7xBBRYBG87q4QQEk%2F02_data_sources_looker_studio.png?alt=media\&token=08fbb8a6-3661-442d-8944-f63e38d1bb2d)

   \
   **or**<br>

   On the **Home page** of the main interface, click the '**Looker Studio**' icon.<br>

   <figure><img src="https://3783386375-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FWbAZwNh39hWp69xdDNc6%2Fuploads%2FG1nIMbpLtahekWiYeioY%2F03_home_looker_studio.png?alt=media&#x26;token=8f6e1954-6055-45f8-a45f-5a5f57d3be18" alt=""><figcaption></figcaption></figure>
3. **Create New Data Source**: Click on '**Create your first Data Source**' in the center of the screen if no Data Sources exist yet.\
   ![](https://3783386375-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FWbAZwNh39hWp69xdDNc6%2Fuploads%2F22pg8hKoWfWdQ0LxV9sv%2F04_create_first_data_source.png?alt=media\&token=b1fedcda-a762-4fc9-b8d9-cb4a3c3bec10)

   If you've previously created Data Sources, select '**+New Data Source**' at the top right corner of the screen.<br>

   <figure><img src="https://3783386375-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FWbAZwNh39hWp69xdDNc6%2Fuploads%2FSXpkZuPnT6F74MS1KM9f%2F05_add_new_data_source.png?alt=media&#x26;token=10516158-76d7-4101-b271-eadb2d25746f" alt=""><figcaption></figcaption></figure>
4. **Select Tables and Fields**: Choose the specific tables and fields you want to include in your Data Source.<br>

   **Available tables for export**\
   In the right section of the main interface, **under each tab** of Jira services, you'll find a list of all **available tables for export**. You can conveniently select the specific tables you need by clicking the '**Plus**' button next to each table. This feature allows for a tailored and efficient export process, ensuring that you export only the necessary data. Additionally, you can easily navigate using the **Search bar**.\
   ![](https://3783386375-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FWbAZwNh39hWp69xdDNc6%2Fuploads%2FYQ9XDGaSCPd2dqq959I2%2F06_available_tables.png?alt=media\&token=4f9ca726-fb16-4acc-8333-7559619a6ee1)

   You can **expand the tables** to view the **available fields** and their **formats**, allowing for a clear understanding of the data structure before exporting.\
   ![](https://3783386375-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FWbAZwNh39hWp69xdDNc6%2Fuploads%2F00w0CZNjQTYSus3QVawN%2F07_expand_tables.jpg?alt=media\&token=00b16dea-8f20-4e28-8ef9-22ce91cd4aee)

   The **complete list** of **tables and fields** that are available for export can be seen [here](https://thecode4.gitbook.io/thecode4-docs/user-guide/tables-and-fields-available-for-export).<br>

While selecting data for export, you may notice 'Star' badges ( ![](https://3783386375-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FWbAZwNh39hWp69xdDNc6%2Fuploads%2Fvh2kfjD661z4nBVCtGy4%2Fstars_xray.png?alt=media\&token=694ef7ac-cb8c-496b-b973-b9c494f1f30b)![](https://3783386375-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FWbAZwNh39hWp69xdDNc6%2Fuploads%2FWr19alx83sQW7G0A5Hhz%2Fstars_pro.png?alt=media\&token=1e17b716-e5c3-484d-a755-10dcd889e2b0)) near the name of some tables.

<div><figure><img src="https://3783386375-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FWbAZwNh39hWp69xdDNc6%2Fuploads%2FXCJ5ze6SS3eBJAjvL3SF%2Fpro_fields.png?alt=media&#x26;token=9032116a-fb76-449f-8f3d-3565dc5af4cc" alt=""><figcaption></figcaption></figure> <figure><img src="https://3783386375-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FWbAZwNh39hWp69xdDNc6%2Fuploads%2F2Z4gQR9CawzAQtSqaFon%2Fxray_fields.png?alt=media&#x26;token=d334a04b-391d-45d7-9792-3ad5b242c91c" alt=""><figcaption></figcaption></figure></div>

These indicate that the table is available for export only with specific paid add-ons, such as **Data Processor for Jira. PRO** or **Data Processor for Xray**. You can find more information about these add-ons in the **Apps** section or on the [**Marketplace**](https://marketplace.atlassian.com/vendors/1225551).<br>

<figure><img src="https://3783386375-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FWbAZwNh39hWp69xdDNc6%2Fuploads%2FjC6lHtxPTDmu25aJJq3C%2FApps_section.png?alt=media&#x26;token=1eb6daff-7460-4ca4-8d80-ee9eeac6156a" alt=""><figcaption></figcaption></figure>

**Selected tables for export**\
Clicking the '**Plus**' button **moves** **tables** from the right section **to** the '**Selected tables for export**' section on the left. Here, you can select the fields for export. Check the box next to a label to select all fields within it, or expand the label to choose individual fields. The count of selected fields versus the total available is displayed next to each label name. You can also easily navigate using the **Search bar**.<br>

<figure><img src="https://3783386375-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FWbAZwNh39hWp69xdDNc6%2Fuploads%2FUpoxBGaZQtvbzGacNHVr%2F08_selected_tables.png?alt=media&#x26;token=27abceb8-3767-4a5d-b0dd-5a1239a61b53" alt=""><figcaption></figcaption></figure>

To remove a table from those selected for export, simply click the ‘**Trash bin**’ button on the right. This will automatically move the table **back to** the '**Available tables for export**' section, allowing you to adjust your selections as needed.<br>

<figure><img src="https://3783386375-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FWbAZwNh39hWp69xdDNc6%2Fuploads%2FDxznflLhP9n2VXubsHpO%2F09_bin_button.png?alt=media&#x26;token=e78dca5f-1e86-4a69-a7eb-1325589b4cac" alt=""><figcaption></figcaption></figure>

While selecting data for export, you may encounter an ‘**Export to Issues**' switch.<br>

<figure><img src="https://3783386375-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FWbAZwNh39hWp69xdDNc6%2Fuploads%2FW0VbK0JGrIS9DUcTIMF5%2F10_export_to_issues.png?alt=media&#x26;token=f345a36a-f6a2-4641-bdf8-ea7379c9603e" alt=""><figcaption></figcaption></figure>

For exporting e.g. **Worklogs** data **linked** **with** **Issues**, there are two options. One is to export Worklogs as a **separate file**. The other is to **integrate Worklogs directly into the Issues file**. In the second option, Worklogs data will be flattened, meaning each Worklogs entry will replicate the corresponding Issues entry, causing duplication in each line where Worklogs are associated. More flexible settings for this feature are planned for future updates.

Here is an **example** of enabled Export to Issues for Worklogs:<br>

<figure><img src="https://3783386375-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FWbAZwNh39hWp69xdDNc6%2Fuploads%2F48Zuh06jfMNW2KGq6C1P%2F11_example_export_to_issue.png?alt=media&#x26;token=3a015429-ad98-4432-8058-d31f9fba0a5c" alt=""><figcaption></figcaption></figure>

Once all data has been selected, click '**Next Step**' to proceed.<br>

<figure><img src="https://3783386375-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FWbAZwNh39hWp69xdDNc6%2Fuploads%2FS9QblqLdVHwqQdWi6jTO%2F12_next_step.png?alt=media&#x26;token=ee05d824-869f-4d44-ae5f-916e45ba3d99" alt=""><figcaption></figcaption></figure>

To activate the ‘**Next Step**’ button and successfully create a data source, you must **select at least one field** in the '**Selected tables for export**’ section.

5. **Apply JQL Filter (Optional)**: Use **JQL** to filter your Jira data, if needed. Click '**Next step**'.<br>

   <figure><img src="https://3783386375-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FWbAZwNh39hWp69xdDNc6%2Fuploads%2FEJkLb2csoka25uR6dXUV%2F13_jql_next_step.png?alt=media&#x26;token=902c8058-9420-411a-b4ce-035bd283439d" alt=""><figcaption></figcaption></figure>

To learn more about JQL and get assistance with its syntax, please refer to [this informative article](https://support.atlassian.com/jira-service-management-cloud/docs/use-advanced-search-with-jira-query-language-jql/). It offers valuable insights and guidelines to help you understand and effectively use JQL for your data queries.

6. **Enter Main Information**: Fill in the Name and optionally, a description for the Data Source. Click '**Save+**'.<br>

   <figure><img src="https://3783386375-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FWbAZwNh39hWp69xdDNc6%2Fuploads%2FqF6ZeSIa6XiLNVfQuCia%2F14_main_info_description_save.png?alt=media&#x26;token=358f62a5-2194-4376-b0d1-d8205875d0e1" alt=""><figcaption></figcaption></figure>
7. **List of Created Data Sources:** After clicking the '**Save+**' button, you will see a list of the created data sources ready for export.<br>

   <figure><img src="https://3783386375-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FWbAZwNh39hWp69xdDNc6%2Fuploads%2FoqjCdYUzuxuiah8QKolc%2F15_list_of_created_data_sources.png?alt=media&#x26;token=f1755da8-8c8f-4b76-92f8-49f68c63c9d5" alt=""><figcaption></figcaption></figure>

***

Identify the data source you need, and you're now **ready to export** your Jira data **into** **Looker Studio**. For a comprehensive guide on how to proceed with this process, please refer to the detailed instructions available [here](https://thecode4.gitbook.io/thecode4-docs/user-guide/export-data-to-the-necessary-bi-tools-or-formats/export-to-looker-studio).

***

Keep in mind that you can navigate between steps using the '**Previous step**' and '**Next step**' buttons, allowing for easy adjustments at any stage of the process.

***

To easily return to the **Home page**, simply click on the **Data Processor Logo** located at the **top left corner**. This provides a quick and straightforward way to navigate back to the main screen.

***

If you've had the chance to use the **BI Exporter for Jira** app, we'd love to hear your **thoughts**. Help us improve by sharing your honest review of the [Free](https://marketplace.atlassian.com/apps/1233034/data-processor-for-jira-multi-bi-connector-free?hosting=cloud\&tab=reviews), [PRO](https://marketplace.atlassian.com/apps/1233504/data-processor-for-jira-link-power-bi-looker-tableau-pro?hosting=cloud\&tab=reviews), [Xray](https://marketplace.atlassian.com/apps/1233855/data-processor-for-xray-power-bi-tableau-looker-connector?hosting=cloud\&tab=reviews) or [Projectrak](https://marketplace.atlassian.com/apps/1235379/bi-exporter-for-projectrak-power-bi-looker-tableau-csv?hosting=cloud\&tab=reviews) versions. Your feedback is crucial as we strive to improve and tailor our services to better meet your needs. 🤝

***

Still have questions? Feel free to [**reach out to us**](https://thecode4.gitbook.io/thecode4-docs/support) for any additional information or to request new features!