Solved: Connect PowerBI to PeopleHR

Anonymous · ‎08-24-2022

I am looking to test connecting the API from People HR to PowerBI to analyse the data more effectively.

Are there any tips anyone had about this?

v-shex-msft · ‎08-30-2022

HI @Anonymous,

This should be based on API setting and credentials permission. You can try to change high permission credentials to get more records.

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

View solution in original post

Anonymous · ‎08-25-2022

@amitchandak thanks for your quick reply. I have been reading up on the notes but I have only seen a few questions from PeopleHR users and looking to see how many have implemented succesfully.

v-shex-msft · ‎08-30-2022

HI @Anonymous,

This should be based on API setting and credentials permission. You can try to change high permission credentials to get more records.

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

amitchandak · ‎08-24-2022

@Anonymous , Seem like API is the suggested way -https://help.peoplehr.com/en/articles/2492019-people-queries-and-excel-power-bi

There are thrid part connectors - https://www.make.com/en/integrations/discord/microsoft-power-bi/people-hr?fromImt=1

!! Integrated Course on Microsoft Fabric, Power BI, and SQL for Free!! !! Master Microsoft Fabric- 31 Videos !!
Microsoft Power BI Learning Resources, 2023 !!
Learn Power BI - Full Course with Dec-2022, with Window, Index, Offset, 100+ Topics !!
Did I answer your question? Mark my post as a solution! Appreciate your Kudos !! Proud to be a Super User! !!

Connect PowerBI to PeopleHR

Helpful resources

Power BI September 2023 Update

Learn Live: Event Series

Exclusive opportunity for Women!

Power Platform Conference-Power BI and Fabric Sessions

How to Get Your Question Answered Quickly