Ehs Insight Enterprise API Connection

[Maheshguptaz]

Hi all,

I'm trying to find an API connection to integrate the EHS Insight application with Power BI Desktop. Any leads on this would be really appreciated.

Thanks in advance!!!

[Nari1998]

Hi, I'm also dealing with same and want to know how to connect it if or when the API is given. Is it through web or advanced editor or somehwere else and how?

[Maheshguptaz]

Hi @Nari1998 ,

Please use Wed as a source to connect and for credentials, use Basic option. 

Username: 

password: API Key

I hope this helps!

[Azhar2010]

Yes, that works, I need assistance with regard to power bi cloud service, I see credentials error there..

I have tried all options like Basic, anonymous etc. it does not work. Can you help how it can be updated through a schedule refresh.

[Nari1998]

Hi, I don't know if this would help. But i found to connect you need to check your API documentation of EHS which you can see in the Get Help Documentation part of your EHS system. Then you connect as anyonomous and then you place the link where url part is and where "add part" is you can add the code of data you want to retrieve.

Then you add the "header" as given below and next box to it you then add the generated API. 

[Azhar2010]

It works in power bi desktop, but does not work when we schedule refresh in power bi cloud service. 

The credentials provided for the Web source are invalid. (Source at https://mycompany.ehsinsight.com/api/v4/entity/ManhourDetails/List.). The exception was raised by the IDbCommand interface. Table: ManHoursDetails.Cluster URI:

[Nari1998]

hi @Maheshguptaz ,

Thank you for your response. Will try that.

And after that do you know how to clean the data because it will load as JSON format right?

[v-stephen-msft]

Hi @Maheshguptaz ,

For using an API as data source, you could refer to

Solved: How to use APIs as a data source? - Microsoft Power BI Community

Calling Power BI API using Power BI Desktop to document Power BI Service - Prathy's Blog...

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Maheshguptaz]

Hi @v-stephen-msft ,

Thank you for your response. I'm aware of API uses, however, I'm looking for an API which would help me connect the EHS Insight application with PBI and I'm not unable to find the right one.

Any suggestions on this would be really helpful.

Thanks in advance!

Regards,

Mahesh