Sage HR API usage

[PYarwood98]

Has anyone used the Sage HR API in Power BI, and if so can you let me know how I can upload this data into Power BI?

I have tried using the Web API using the API key provided by the software but it not working.

Regards

[Anonymous]

Hi,@PYarwood98 .I am glad to help you.

I recommend that you use the M-code Web.Contents provided in Power BI to connect to third-party API data sources.
Set the corresponding data source credentials (username  &token) in the function
Solved: Using The RelativePath And Query Options With Web.... - Microsoft Fabric Community
 Web.Contents - PowerQuery M | Microsoft Learn

Power BI Connector using web connectivity
Solved: Encountering SSL TLS error in web connection - Microsoft Fabric Community
API Reference | Sage Developer
I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Carson Jian,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[PYarwood98]

I am struggling to get Web.Content to work as a source in Power BI M Code, I tried the example from the Web.Content learning link above and nothing has happened with the data, see the visual I have based on the example:

The example I used was below:

If I cannot get the examples to work on Desktop I will struggle to get the coding right for the Sage HR API process.

Any ideas?

[PYarwood98]

I am struggling to get Web.Content to work as a source in Power BI M Code, I tried the example from the Web.Content learning link above and nothing has happened with the data, see the visual I have based on the example:

The example I used was below:

If I cannot get the examples to work on Desktop I will struggle to get the coding right for the Sage HR API process.

Any ideas?