# Get data from lookup table in commcare to Power BI

**URL:** <https://forum.dimagi.com/t/get-data-from-lookup-table-in-commcare-to-power-bi/8527>\
**Category:** Users\
**Created:** [October 25, 2021, 11:31am UTC](https://forum.dimagi.com/t/get-data-from-lookup-table-in-commcare-to-power-bi/8527 "2021-10-25T11:31:41Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![malbakoor](https://dimagi.b-cdn.net/letter_avatar_proxy/v4/letter/m/e47c2d/32.png) [@malbakoor](https://forum.dimagi.com/u/malbakoor)\
**Post date:** [October 25, 2021, 11:31am UTC](https://forum.dimagi.com/t/get-data-from-lookup-table-in-commcare-to-power-bi/8527/1 "2021-10-25T11:31:41Z")

</div>

Hi all  
i have a look up table in commcare and i want to get the data in this table to power bi report .  
Is this possible within commcare?  
How is it? Import a look up table from Commcare to Power PI  
thanx

 ![tempsnip](https://dimagi.b-cdn.net/uploads/default/original/2X/0/0f0c5b8b6ab986ec2dfe108aa1779d8c88a61f13.png)

---

<div class="post-metadata">

**Author:** ![guillaume](https://dimagi.b-cdn.net/user_avatar/forum.dimagi.com/guillaume/32/1381_2.png) [@guillaume](https://forum.dimagi.com/u/guillaume)\
**Post date:** [October 25, 2021, 12:45pm UTC](https://forum.dimagi.com/t/get-data-from-lookup-table-in-commcare-to-power-bi/8527/2 "2021-10-25T12:45:14Z")

</div>

Hi,

To my knowledge there is no way to do this. If you really need to have this data in PBI, you could store this data in a case and then create a OData feed for this case

Cheers,