# Missing Products in PowerBI

**URL:** <https://community.piwik.pro/t/missing-products-in-powerbi/4465>\
**Category:** Reports and working with data\
**Created:** [September 30, 2024, 3:17pm UTC](https://community.piwik.pro/t/missing-products-in-powerbi/4465 "2024-09-30T15:17:43Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Martin](https://avatars.discourse-cdn.com/v4/letter/m/73ab20/32.png) [@Martin](https://community.piwik.pro/u/Martin)\
**Post date:** [September 30, 2024, 3:17pm UTC](https://community.piwik.pro/t/missing-products-in-powerbi/4465/1 "2024-09-30T15:17:43Z")

</div>

Hi,

I have to switch from Lookerstudio to PowerBI.  
I followed the instructions [Microsoft Power BI Desktop integration | Piwik PRO help center](https://help.piwik.pro/support/integrations/microsoft-power-bi-desktop-integration/) and connected Piwik with PowerBI.

Not all is running smoothly but thats for another topic.

My biggest issue, I cant see products , such as pruduct name, variant etc and see which product made revenue etc.  
Following [Columns — Piwik PRO Analytics Suite 18.27 documentation](https://developers.piwik.pro/en/latest/custom_reports/columns.html) there should be product name etc. But as in the Spreadsheet connector there are no product dimensions.

In Looker its been a piece of cake.

Is there a guide for this topic or what seems to be the problem?

Regards Martin

---

<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 3, 2024, 9:14am UTC](https://community.piwik.pro/t/missing-products-in-powerbi/4465/2 "2024-10-03T09:14:39Z")

</div>

Hi @Martin,

Do you have the e-commerce module enabled for this particular site?

I mean this setting (Administration \> Reports):

 ![image](https://europe1.discourse-cdn.com/flex005/uploads/piwikpro/original/2X/9/9132efba9c789422596671d0ac0c3a9364aa3351.png)

---

<div class="post-metadata">

**Author:** ![Martin](https://avatars.discourse-cdn.com/v4/letter/m/73ab20/32.png) [@Martin](https://community.piwik.pro/u/Martin)\
**Post date:** [October 4, 2024, 5:44am UTC](https://community.piwik.pro/t/missing-products-in-powerbi/4465/3 "2024-10-04T05:44:05Z")

</div>

Hi Anthony,  
yes, ecommerce is enabled. Its working fine for the interface and Looker Studio. Its just missing in the raw data for Spreadsheet and PowerBI

---

<div class="post-metadata">

**Author:** ![system](https://europe1.discourse-cdn.com/flex005/uploads/piwikpro/original/1X/db7013c4fd6a24443b339309db52f14995207737.png) [@system](https://community.piwik.pro/u/system)\
**Post date:** [October 18, 2024, 5:44am UTC](https://community.piwik.pro/t/missing-products-in-powerbi/4465/4 "2024-10-18T05:44:42Z")

</div>

This topic was automatically closed 14 days after the last reply. New replies are no longer allowed.