Skip to main content
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Frequent Visitor

Power BI connection to iTrent


Does anyone know how to use Power BI to get data from iTrent?

It's a widely used online HR system from MHR, but there seems to be no documentation for it relating to Power BI or an API. I can sign in to it direct so i know my access works. However, I can't connect Power BI to it after trying several variations on using Get Data from Web along with the website address, my username and password. The Basic option looked most promising but won't accept my credentials. Neither will any other option I've tried in that dialog box. 

I'm still getting to grips with how to get data from external web applications so I could be missing something obvious.


Any ideas? Has anyone else connected to iTrent and know how I can get Power BI to get data from it?



Frequent Visitor

Thanks. I saw that page but it just says that documentation exists, but doesn't contain the actual doc itself. I'm still trying to track it down. If anyone has a link to the document itself then let me know in the next few days. Otherwise, I'll accept this as the closest answer I'm likely to get. Thanks again.


This article suggests there is an API and documentation for it.  Looks like you can authenticate with a key or with username/password.

MHR iTrent Integrated HR and Payroll - Digital Marketplace




Did I answer your question? Mark my post as a solution! Kudos are also appreciated!

To learn more about Power BI, follow me on Twitter or subscribe on YouTube.

@mahoneypa HoosierBI on YouTube

Helpful resources

Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City


Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors