# API intergeration with PowerBI

**URL:** <https://community.hubspot.com/t/api-intergeration-with-powerbi/116641>\
**Category:** APIs & Integrations\
**Tags:** starter\
**Created:** [September 19, 2024, 7:11am UTC](https://community.hubspot.com/t/api-intergeration-with-powerbi/116641 "2024-09-19T07:11:42Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![iisrar](https://avatars.discourse-cdn.com/v4/letter/i/a587f6/32.png) [@iisrar](https://community.hubspot.com/u/iisrar)\
**Post date:** [September 19, 2024, 7:11am UTC](https://community.hubspot.com/t/api-intergeration-with-powerbi/116641/1 "2024-09-19T07:11:42Z")

</div>

Hello  
I need urgent help, so I am trying to integerate HubSpot with PowerBI using API endpoints.  
[https://api.hubapi.com/crm/v3/objects/contacts?properties=\*&archived=false](https://api.hubapi.com/crm/v3/objects/contacts?properties=*&archived=false)  
By using the above endpoint, I am not getting all the properties of the contact as it should be but if I specify specific properties I do get them.  
I am really stuck with this problem and new to HubSpot and its integeration.  
Please help

---

<div class="post-metadata">

**Author:** ![dsmarion](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/dsmarion/32/7509_2.png) [@dsmarion](https://community.hubspot.com/u/dsmarion)\
**Post date:** [September 19, 2024, 11:01am UTC](https://community.hubspot.com/t/api-intergeration-with-powerbi/116641/2 "2024-09-19T11:01:24Z")

</div>

You do need to specifically ask for the properties you want returned, otherwise you will only receive a few default standard properties. This is true for all the objects, not just contacts.