How to transfer Personio data to Power BI with API?

Dear @marielle.van.wieringen,

Thank you very much for sharing this question with us. I have investigated internally and found some comments in our German Community about how to integrate Personio with Power BI.

• One of the users shared that they use our integration with Zapier, to transfer the information from Personio to Power BI. I am waiting for more input about this option and will share it with you asap. 

• The second solution is very technical. I translated the user’s solution from the German community to English, but this is not a process we in Personio are familiarized with, since it is set up in the API and Power BI. Nevertheless, I share it with you, hoping it is helpful:
  • The current solution for the connection to the Personio API is, instead of the direct connection, to use a self-created HTTPS interface in Power Automate:

Before each GET/POST/DELETE a https auth request must be sent via POST. (For this you need the client ID and client secret, which can be generated in Personio under Settings > Integrations > API Credentials). The response is the token, which must then be sent as a "bearer" in the form of a short-term and one-time valid key when the actual request/task is sent.

If these functions are all represented with variables in Power Automate, they can be used by another web page or "app". For example, functions can be integrated into a Sharepoint, a PowerApp, a PowerBI report, or any app. Through Microsoft's on-premise gateway, these applications can also run locally on the corporate network and then connect to the WWW.

You can share the need of this integration as always in our ideation area, or/ and vote for this integration in this link.

I will let you know what I could investigate internally about the integration through Zapier. 

Thank you for your patience!

Best,

Andrea

Hi Andrea,

Thanks and hope to get an update about the Zapier integration.

Kind regards, Marielle

Hello there,

@marielle.van.wieringen you could try using Power Bi Template App (Power BI for Personio): Power BI for Personio (microsoft.com)

More information can be found here: Power BI for Personio | SAB Analytics

Have a nice Day!

Hey there! 

Is it also possible to execute this use case through the Albato automation platform?

They already have integration with Power BI - https://albato.com/apps/powerbi

Hi @WDIAS29,

if you cannot find the integration you need in the Personio Marketplace, you can request it or build your own integration using Personio's Public APIs.

You can use Personio Public APIs to exchange data between Personio and other services or tools. These APIs allow you to connect Personio to databases or integrate with third-party providers. The APIs offer several endpoints to retrieve and edit data from your Personio account, including employee data, attendance data, absence data, document metadata, and compensation values.

🔗 Personio Public APIs
🔗 Build your own integration with our APIs

In this case, the Developer Hub is your primary resource, where you can find all the information related to Personio APIs broken down by categories:

• The Documentation section provides all the guidelines and requirements for starting with the Personio APIs.
• In the API Reference section, you will find detailed descriptions of each API endpoint and instructions on how to use them.
• The Changelog contains the latest updates and additions to the APIs.
• You can also ask your questions in the Discussions section.

If needed, you can also request an Office Hour with our Integration Services team, which will be able to provide any further information and assistance during this process.

I hope this helps!

Cheers,

Valentina 🍁