# Is it possible to load PIWIK data into microsoft one lake? **URL:** \ **Category:** Reports and working with data\ **Created:** [July 21, 2023, 10:45am UTC](https://community.piwik.pro/t/is-it-possible-to-load-piwik-data-into-microsoft-one-lake/2626 "2023-07-21T10:45:25Z")\ **Posts on this page:** 3\ **Page:** 1
**Author:** ![Leralix](https://dub1.discourse-cdn.com/flex005/user_avatar/community.piwik.pro/leralix/32/2007_2.png) [@Leralix](https://community.piwik.pro/u/Leralix)\ **Post date:** [July 21, 2023, 10:45am UTC](https://community.piwik.pro/t/is-it-possible-to-load-piwik-data-into-microsoft-one-lake/2626/1 "2023-07-21T10:45:25Z")
It seems that the PIWIK power bi connector only work for the desktop version. Is there a way of exporting the session and event table ? I know how to load it into one Lake after that. As seen on the doc, the HTTP API only load raw session. Is that all that we can load ? Thanks Thibaud ---
**Author:** ![Michal\_Szczerek](https://dub1.discourse-cdn.com/flex005/user_avatar/community.piwik.pro/michal_szczerek/32/1493_2.png) [@Michal\_Szczerek](https://community.piwik.pro/u/Michal_Szczerek)\ **Post date:** [July 21, 2023, 10:48am UTC](https://community.piwik.pro/t/is-it-possible-to-load-piwik-data-into-microsoft-one-lake/2626/2 "2023-07-21T10:48:21Z")
Hi, Power BI Online is in the works. You can export session and event raw data via HTTP API like you mentioned. You also have access to query API → [HTTP API — Piwik PRO Analytics Suite 17.6 documentation](https://developers.piwik.pro/en/latest/custom_reports/http_api/http_api.html) Raw data contains all of the data so it should match your expectations I believe 🙂 ---
**Author:** ![Leralix](https://dub1.discourse-cdn.com/flex005/user_avatar/community.piwik.pro/leralix/32/2007_2.png) [@Leralix](https://community.piwik.pro/u/Leralix)\ **Post date:** [July 24, 2023, 1:32pm UTC](https://community.piwik.pro/t/is-it-possible-to-load-piwik-data-into-microsoft-one-lake/2626/3 "2023-07-24T13:32:51Z")
Hello, This solved my issue. Thank you !