# How to export all Piwik Pro data?

**URL:** <https://community.piwik.pro/t/how-to-export-all-piwik-pro-data/2308>\
**Category:** Reports and working with data\
**Created:** [May 31, 2023, 9:26am UTC](https://community.piwik.pro/t/how-to-export-all-piwik-pro-data/2308 "2023-05-31T09:26:44Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Yaya](https://avatars.discourse-cdn.com/v4/letter/y/cdc98d/32.png) [@Yaya](https://community.piwik.pro/u/Yaya)\
**Post date:** [May 31, 2023, 9:26am UTC](https://community.piwik.pro/t/how-to-export-all-piwik-pro-data/2308/1 "2023-05-31T09:26:44Z")

</div>

Hi, I am currently using the free version of Piwik Pro. My goal is to create a dashboard in Power BI to monitor the performance of my website.

As I don’t know everything that is collected by Piwik Pro, I want to export all the data to explore it in my reporting in order to choose the KPIs that are relevant to my business.

Could you explain how to export all the data collected by Piwik Pro?  
Thank you in advance.

---

<div class="post-metadata">

**Author:** ![anthonybartczak](https://dub1.discourse-cdn.com/flex005/user_avatar/community.piwik.pro/anthonybartczak/32/2430_2.png) [@anthonybartczak](https://community.piwik.pro/u/anthonybartczak)\
**Post date:** [May 31, 2023, 9:35am UTC](https://community.piwik.pro/t/how-to-export-all-piwik-pro-data/2308/2 "2023-05-31T09:35:15Z")

</div>

Hi Yaya!

The quickest way to access your Piwik PRO raw data is to use the Raw Data API:

> **[HTTP API](https://developers.piwik.pro/en/latest/custom_reports/http_api/http_api.html#tag/Raw-data)**

---

<div class="post-metadata">

**Author:** ![thomasgerstmann](https://dub1.discourse-cdn.com/flex005/user_avatar/community.piwik.pro/thomasgerstmann/32/864_2.png) [@thomasgerstmann](https://community.piwik.pro/u/thomasgerstmann)\
**Post date:** [September 29, 2023, 10:11pm UTC](https://community.piwik.pro/t/how-to-export-all-piwik-pro-data/2308/3 "2023-09-29T22:11:06Z")

</div>

Hi @anthonybartczak, in the linked developer/API documentation I can only find parameters to specify single columns for export. Is it possible to define ALL columns (“columns=\*”) for export, so that a complete dump can be exported via the HTTP API without mentioning each single column? Kind regards Thomas

---

<div class="post-metadata">

**Author:** ![anthonybartczak](https://dub1.discourse-cdn.com/flex005/user_avatar/community.piwik.pro/anthonybartczak/32/2430_2.png) [@anthonybartczak](https://community.piwik.pro/u/anthonybartczak)\
**Post date:** [October 4, 2023, 10:30am UTC](https://community.piwik.pro/t/how-to-export-all-piwik-pro-data/2308/4 "2023-10-04T10:30:05Z")

</div>

Hi @thomasgerstmann!

Please excuse me for the late response. As of now it’s not possible to define all of the columns with such wildcard. You have to define the column names (each one of them). That might change in the future, so I recommend keeping an eye on the changelog.